JOIN DISTINCT COLLECT or JOIN INDEX COLLECT w/ Multi Dropdown List

ShelbyWarren
ShelbyWarren ✭✭✭✭✭
edited 04/21/23 in Formulas and Functions

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

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!