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
- 63.7K Get Help
- 406 Global Discussions
- 218 Industry Talk
- 457 Announcements
- 4.7K Ideas & Feature Requests
- 141 Brandfolder
- 136 Just for fun
- 57 Community Job Board
- 459 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 297 Events
- 37 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!