Help

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

Topic Labels: Formulas
Solved
Jump to Solution
779 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!