Help

Upcoming database upgrades. Airtable functionality will be reduced for ~15 minutes at 06:00 UTC on Feb. 4 / 10:00 pm PT on Feb. 3. Learn more here

Nested IF Concatenate

Topic Labels: Formulas
Solved
Jump to Solution
264 2
cancel
Showing results for 
Search instead for 
Did you mean: 

Hi. I would appreciate help with the following:

I have the fields Country (required field), Region and Title. I need to concatenate these fields in different ways depending on which fields are filled.

-If just Region is filled then Region, Country
-If just Title is filled then Country- ‘Title’
-If both Region and Title are filled then Region, Country- ‘Title’
-If neither are filled then Country

Thank you in advance for any help.

Katy

1 Solution

Accepted Solutions
IF({Region}, {Region} & ", ", "") &
{Country} &
IF({Title}, "- '" & {Title} & "'", "")

See Solution in Thread

2 Replies 2
IF({Region}, {Region} & ", ", "") &
{Country} &
IF({Title}, "- '" & {Title} & "'", "")

Amazing! Thank you so much @Kamille_Parks!!