- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎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.
Accepted Solutions
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Apr 30, 2024 09:36 PM
Does this look right? 
IF(
{Spouse name},
Name & " and " & {Spouse name},
Name
)
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Apr 30, 2024 09:36 PM
Does this look right? 
IF(
{Spouse name},
Name & " and " & {Spouse name},
Name
)
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎May 01, 2024 06:29 AM
Yes! That worked! Thank you so much!
