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!
