Join Collect formula for multiple values

Is it possible to use a Join / Collect formula, which references a multi-select dropdown list in one sheet to find and query an array of values?

In Sheet 1, I'm querying a set of values however I can't seem to pull anything forward when multiple values are listed in the Client Name column. I'm trying to pull forward every Intake ID # (Sheet 2) for each Client Name (Sheet 1).

So ideally the empty cell below would read "OPS12, OPS33".

=JOIN(COLLECT([Client Name]@row, [Client Name]@row, CONTAINS(@cell, {Column_Client Name})), ",")

Sheet 1

Sheet 2



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!