Nested IF Concatenate

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.


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

Amazing! Thank you so much @Kamille_Parks!!

This topic was solved and automatically closed 3 days after the last reply. New replies are no longer allowed.