Help

Re: Formula for if one field is blank then choose another field

Solved
Jump to Solution
1112 2
cancel
Showing results for 
Search instead for 
Did you mean: 
Michelle-T
4 - Data Explorer
4 - Data Explorer

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
ScottWorld
18 - Pluto
18 - Pluto

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
ScottWorld
18 - Pluto
18 - Pluto

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}
)
Michelle-T
4 - Data Explorer
4 - Data Explorer

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: