Concatenating Contacts List Columns but Omitting One Option
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.
Best Answer
-
You would use something along the lines of
=[Program Lead]@row + IF([Internal Speaker]@row <> "Not Applicable", "delimiter of choice" + [Internal Speaker]@row, "")
Answers
-
You would use something along the lines of
=[Program Lead]@row + IF([Internal Speaker]@row <> "Not Applicable", "delimiter of choice" + [Internal Speaker]@row, "")
-
Amazing thanks so much Paul!!
-
Happy to help. 👍️
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.5K Get Help
- 424 Global Discussions
- 136 Industry Talk
- 465 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 146 Just for fun
- 63 Community Job Board
- 465 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 301 Events
- 39 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!