Help

Upcoming database upgrades. Airtable functionality will be reduced for ~15 minutes at 06:00 UTC on Feb. 4 / 10:00 pm PT on Feb. 3. Learn more here

IF Formula for naming a field

Topic Labels: Formulas
177 6
cancel
Showing results for 
Search instead for 
Did you mean: 

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!

6 Replies 6

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

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 :slightly_smiling_face:

:rofl: too funny - and good point!