The Community will be temporarily unavailable starting on Friday February 28. We’ll be back as soon as we can! To learn more, check out our Announcements blog post.

Concatenate merging 3 fields only if not empty

posted Mar 20, 2022 12:06:03 PM

Topic Labels: Formulas

0 710 0

I have up to 3 fields that I want to merge together and separate each field with a comma, but only if the field is not empty. If any of the 3 fields are empty, I don’t want them included so that I don’t have extra commas in the resulting formula field.
Any ideas how I achieve this?

0 Replies 0

Concatenate merging 3 fields only if not empty

Ugh - struggling with merging content

Merging date fields

merge problem - field not available

Concatenated text field in automation

Formula formatting for Email merge field