IF Formula for naming a field

[Leah_Relish]

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!

[TheTimeSavingCo]

Hi Leah, could you try the following?

IF(
  {Company},
  {Company},
 {Last Name} & " - " & {First Name}
)

Edit: Fixed the error kuovonne pointed out below!

[kuovonne]

Adam_TheTimeSavingCo:

{Last Name} - {First Name}

I think you mean

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

Otherwise you are trying to do math with names.

[kuovonne]

Leah_Relish:

a formula for naming the main field in a table.

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

[TheTimeSavingCo]

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

Thanks!

[Leah_Relish]

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

Thank you :slightly_smiling_face:

[Leah_Relish]

:rofl: too funny - and good point!