What formula(s) do I use to reference a Multi-select column in another sheet?

Jim Rood

Normally I use Index(Match()) to pull in the value from one row into another sheet. That doesn't appear to work when the source is a multi-select column. I've tried Index(Collect()) but can't seem to get the syntax right. Any help would be greatly appreciated.

Paul H

Try the HAS function

https://help.smartsheet.com/function/has

Jim Rood

Thanks but I don't see how that would work for my use case. I'm essentially trying to pass the values selected within the Team cell to another sheet where the Login ID is the same using a cross sheet reference. I'm trying to retain the characteristics of the multi-select column in the look up sheet when returned to the destination sheet. Hope this helps clarify.

Paul H

If you want to bring in all selected values try an Index + match with a substitute to add line break back in