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!!
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}
)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
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:
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.