Skip to main content

Hello 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!

Hi Leah, could you try the following?


IF(

  {Company},

  {Company},

 {Last Name} & " - " & {First Name}

)

Edit: Fixed the error kuovonne pointed out below!

Hi 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.


Formulas can set cell values. Formulas cannot change the name of a field (the column heading).


I 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!

Hi 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 🙂

Hahahha now you’ve got me thinking about how I would deduct a first name from a last name


Thanks!


🤣 too funny - and good point!

Reply


Terms & Conditions