Multiselect Dropdown Parsing
Hello all,
I have 3 columns in a sheet. 1 is a multi-select dropdown ("MSD"), 1 is a single contact ("SC"), and 1 is a multi-select contact ("MSC"). In the SC, I want to take the first dropdown value from the MSD and use it to index match a value from another sheet. In the MSC, then I want to take the remaining values from the MSD and index match those values individually from another sheet. I don't foresee more than 3 values in the MSD. Is this possible?
Best Answer
-
Technically yes. You can pull these values in based on the multi-select dropdown, but...
We cannot currently use formulas to populate multiple USABLE contacts in a single cell even if the column is set to allow multiple. It will simply generate a text string and won't be usable in automations for notifications, update requests, etc..
Answers
-
Technically yes. You can pull these values in based on the multi-select dropdown, but...
We cannot currently use formulas to populate multiple USABLE contacts in a single cell even if the column is set to allow multiple. It will simply generate a text string and won't be usable in automations for notifications, update requests, etc..
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.1K Get Help
- 382 Global Discussions
- 212 Industry Talk
- 444 Announcements
- 4.6K Ideas & Feature Requests
- 140 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 451 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 291 Events
- 35 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!