Skip to main content

Hi! I am using airtable to keep track of several types of info connected to individual clients. However, sometimes I need partners/spouses' names to be in the same column. Is there a way to write a formula that only runs when certain conditions are met?

For example, as seen in the picture below, my current formula for IN PROGRESS: Client and Spouse column is 

{First Name (from Spouse/Partner)} & ' and ' & ({Full Name})
 
I would like that formula to run IF there is a spouse, and I would like the IN PROGRESS: Client and Spouse column to only populate info from the Full Name column if there is no spouse/partner.

I tried writing IF statements, but I couldn't figure out.

Thank you!

Does this look right? 

IF(

{Spouse name},

Name & " and " & {Spouse name},

Name

)

Does this look right? 

IF(

{Spouse name},

Name & " and " & {Spouse name},

Name

)

Yes! That worked! Thank you so much!

Reply


Terms & Conditions