Save the date! Join us on October 16 for our Product Ops launch event. Register here.
Apr 30, 2024 09:25 AM
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
I tried writing IF statements, but I couldn't figure out.
Thank you!
Solved! Go to Solution.
Apr 30, 2024 09:36 PM
Does this look right?
IF(
{Spouse name},
Name & " and " & {Spouse name},
Name
)
Apr 30, 2024 09:36 PM
Does this look right?
IF(
{Spouse name},
Name & " and " & {Spouse name},
Name
)
May 01, 2024 06:29 AM
Yes! That worked! Thank you so much!