The Community will be temporarily unavailable starting on Friday February 28. We’ll be back as soon as we can! To learn more, check out our Announcements blog post.
‎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!