+9Hello Community!
I am struggling with writing a formula for naming the main field in a table.
I would like the formula to name the field {Company} if the field {Company} is not blank and name the field {Last Name} - {First Name} if the {Company} field is blank.
I just can’t seem to get it right. Can anyone help?
Thanks!
+31Hi Leah, could you try the following?
IF(
{Company},
{Company},
{Last Name} & " - " & {First Name}
)
Edit: Fixed the error kuovonne pointed out below!
+29Hi Leah, could you try the following?
IF(
{Company},
{Company},
{Last Name} & " - " & {First Name}
)
Edit: Fixed the error kuovonne pointed out below!
I think you mean
{Last Name} & " - " & {First Name}
Otherwise you are trying to do math with names.
+29Formulas can set cell values. Formulas cannot change the name of a field (the column heading).
+31I think you mean
{Last Name} & " - " & {First Name}
Otherwise you are trying to do math with names.
Hahahha now you’ve got me thinking about how I would deduct a first name from a last name
Thanks!
+9Hi Leah, could you try the following?
IF(
{Company},
{Company},
{Last Name} & " - " & {First Name}
)
Edit: Fixed the error kuovonne pointed out below!
YES! You are amazing. I was totally over complicating it.
Thank you :slightly_smiling_face:
+9Hahahha now you’ve got me thinking about how I would deduct a first name from a last name
Thanks!
:rofl: too funny - and good point!
No account yet? Create an account
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.