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, "")
Come see me in Seattle at ENGAGE 2024! I will be at the 10xViz partner booth throughout as well as the "Lets Talk About Community" Meet & Eat table on Tuesday from 11:45am - 12:45pm!
Answers
-
You would use something along the lines of
=[Program Lead]@row + IF([Internal Speaker]@row <> "Not Applicable", "delimiter of choice" + [Internal Speaker]@row, "")
Come see me in Seattle at ENGAGE 2024! I will be at the 10xViz partner booth throughout as well as the "Lets Talk About Community" Meet & Eat table on Tuesday from 11:45am - 12:45pm!
-
Amazing thanks so much Paul!!
-
Happy to help. 👍️
Come see me in Seattle at ENGAGE 2024! I will be at the 10xViz partner booth throughout as well as the "Lets Talk About Community" Meet & Eat table on Tuesday from 11:45am - 12:45pm!
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.8K Get Help
- 376 Global Discussions
- 207 Industry Talk
- 440 Announcements
- 4.5K Ideas & Feature Requests
- 139 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 284 Events
- 33 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!