Formula for if one field is blank then choose another field

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.

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:

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