Help with formula looking up values from 2 columns

Airtable Questions Fields and Formulas
1

What formula would you use to lookup a value in column 1, if no value, use value in column 2?

I have a new column “User Company Name” that I want to pull the value from either “Customer Name” or “CM Name”. I tried this formula- IF({Customer Name}, {CM Name}) with no luck.

You will see one column is linked, the other a lookup. Any help would be greatly appreciated. The names used in tables are fictional, examples only.

Screenshot 2023-06-16 at 12.02.43 PM
Screenshot 2023-06-16 at 12.02.43 PM1336×1156 82.6 KB

2

Hey @airtablewhitebelt!

Try

IF(Customer Name, Customer Name, CM Name)

This says IF Customer Name, use Customer Name, otherwise use CM Name

3

That works. Thank you for your help! Much appreciated!

4

You bet! Glad it worked for you.