Help

Nested IF Concatenate

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

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
Kamille_Parks
16 - Uranus
16 - Uranus
IF({Region}, {Region} & ", ", "") &
{Country} &
IF({Title}, "- '" & {Title} & "'", "")

See Solution in Thread

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

Amazing! Thank you so much @Kamille_Parks!!