JOIN DISTINCT COLLECT or JOIN INDEX COLLECT w/ Multi Dropdown List
Hi,
I want to return the "Assigned to" contact for the "Assignee Role(s)" selected in a multi-select dropdown list.
Here are the formulas I've tried so far:
JOIN(DISTINCT(COLLECT({Project Settings - Team Members}, {Project Settings - Contact Role}, CONTAINS([Assignee Role]@row, @cell))), ", "))
JOIN(INDEX(COLLECT({Project Settings - Team Members}, {Project Settings - Contact Role}, CONTAINS([Assignee Role]@row, @cell)), 1), ", "))
Answers
-
We currently cannot use a formula to string together multiple usable contacts within the same cell. We can pull the contacts together as a text string, but you will not be able to use it as a contact type data for filters, automations, etc.
-
@Paul Newcome I'm ok with it not returning the actual contact info. As long as the text string of the name returns - it's good.
-
Try a HAS function instead of CONTAINS.
-
The HAS function seems to only return the first value it finds. However, in this scenario, there could be multiple Roles selected, which would require multiple names in the contact column.
-
Can you post the formula with the HAS function?
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 64.1K Get Help
- 413 Global Discussions
- 221 Industry Talk
- 459 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 141 Just for fun
- 58 Community Job Board
- 461 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 299 Events
- 38 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!