Concatenating Contacts List Columns but Omitting One Option

Samantha McDonald

I have two contact list columns that I need to combine into one column. One of the columns however has "Not Applicable" as an option. How do I concatenate both columns but not include any instances of "Not Applicable".

Contact Columns are Program Lead and Internal Speaker (this is the column which contains "Not Applicable" as an option.

Paul Newcome

You would use something along the lines of

=[Program Lead]@row + IF([Internal Speaker]@row <> "Not Applicable", "delimiter of choice" + [Internal Speaker]@row, "")

Paul Newcome

You would use something along the lines of

=[Program Lead]@row + IF([Internal Speaker]@row <> "Not Applicable", "delimiter of choice" + [Internal Speaker]@row, "")

Samantha McDonald

Amazing thanks so much Paul!!

Paul Newcome

Happy to help. 👍️

KellyDr

@Samantha McDonald , is your concatenated row a Contact List column type? I was able to concatenate 2 contacts lists into one column, but the resulting column is text only and won't then work with the 'Current User' functionality.