Skip to main content

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

IF({Region}, {Region} & ", ", "") &

{Country} &

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


IF({Region}, {Region} & ", ", "") &

{Country} &

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

Amazing! Thank you so much @Kamille_Parks!!

Reply


Terms & Conditions