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

Formula for if one field is blank then choose another field

Topic Labels: Formulas
Solved
Jump to Solution
581 4
cancel
Showing results for 
Search instead for 
Did you mean: 

Hi all, I’m literally just starting out, but trying to make my primary field choose the correct investor (either personal or corporate). Is there a way to make this work in something like this format:

IF(
{Company Name}!=BLANK(),
{Company Name})
ELSE(
{Last Name})

The first part of the string works, but I can’t get the second part to work. Any suggestions would be greatly appreciated.

1 Solution

Accepted Solutions

Welcome to the community, @Michelle-T!

There is no “Else” statement in Airtable, and you can also just test for the presence of a field’s value by using its name. So your formula could look like this:

IF(
{Company Name},
{Company Name},
{Last Name}
)

See Solution in Thread

4 Replies 4

Welcome to the community, @Michelle-T!

There is no “Else” statement in Airtable, and you can also just test for the presence of a field’s value by using its name. So your formula could look like this:

IF(
{Company Name},
{Company Name},
{Last Name}
)

OMG thank you! I feel like such a dummy now! that was so easy!!

Hi again, just out of curiosity, can i add the first name field as well? I have been trying, but I can’t make it show up.
Thanks!
Michelle

Here you go:

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

This documentation might be helpful for you: