IF Formula for naming a field

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!

1 Like

I think you mean

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

Otherwise you are trying to do math with names.

1 Like

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

1 Like

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

Thanks!

YES! You are amazing. I was totally over complicating it.

Thank you :slight_smile:

:rofl: too funny - and good point!

This topic was solved and automatically closed 15 days after the last reply. New replies are no longer allowed.