Skip to main content
Solved

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

A

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!

Best answer by TheTimeSavingCo

Does this look right? 

IF(
{Spouse name},
Name & " and " & {Spouse name},
Name
)
View original
Did this topic help you find an answer to your question?

2 replies

TheTimeSavingCo
Forum|alt.badge.img+18

Does this look right? 

IF(
{Spouse name},
Name & " and " & {Spouse name},
Name
)
Adam, Consultant @ The Time Saving Co
A
  • Admin_LI
  • Author
  • New Participant
  • 3 replies
  • May 1, 2024
TheTimeSavingCo wrote:

Does this look right? 

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

Yes! That worked! Thank you so much!

TheTimeSavingCo
1 person likes this
  • TheTimeSavingCo
    TheTimeSavingCo

Reply


Most helpful members this week

Terms & Conditions