Help

Save the date! Join us on October 16 for our Product Ops launch event. Register here.

Formula for combining data from two columns when certain conditions are met

Topic Labels: Formulas
Solved
Jump to Solution
681 2
cancel
Showing results for 
Search instead for 
Did you mean: 
Admin_LI
5 - Automation Enthusiast
5 - Automation Enthusiast

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!

1 Solution

Accepted Solutions
TheTimeSavingCo
18 - Pluto
18 - Pluto

Does this look right? 

Screenshot 2024-05-01 at 12.36.37 PM.png

IF(
  {Spouse name},
  Name & " and " & {Spouse name},
  Name
)

See Solution in Thread

2 Replies 2
TheTimeSavingCo
18 - Pluto
18 - Pluto

Does this look right? 

Screenshot 2024-05-01 at 12.36.37 PM.png

IF(
  {Spouse name},
  Name & " and " & {Spouse name},
  Name
)

Yes! That worked! Thank you so much!