What formula(s) do I use to reference a Multi-select column in another sheet?
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.
Answers
-
Try the HAS function
-
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.
-
If you want to bring in all selected values try an Index + match with a substitute to add line break back in
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.1K Get Help
- 380 Global Discussions
- 212 Industry Talk
- 442 Announcements
- 4.6K Ideas & Feature Requests
- 140 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 450 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 289 Events
- 34 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!