Can I turn comma separated lists into multiple-choice dropdowns?
The title basically says it all. I have a column that was built in Excel, with multiple items separated by commas (no spaces) to make a string of about 1-5 items. We're moving our processes into Smartsheet, and I want this information to be formatted as a dropdown column with each item chosen as a separate entry.
Smartsheet doesn't seem to be able to support this very easily. Does anyone have a suggestion for a formula or other solution that would automate the multiple choice selection?
This is an oversimplified version, but what I'm looking to achieve:
Any help/thoughts would be appreciated! Just learning Smartsheets and it's an adventure for sure :)
Best Answer
-
Hi @sarahsfocused,
I believe that
is a third party application that might solve this problem. I have never used it before and I cannot vouch for it in anyway whatsoever.Other than that, I found this thread which seems similar to this one:
I don't think it's possible within SmartSheet at the moment. You can use the SmartSheet API, which is what DDUpdate does. The SmartSheet API is free, so if you have a coder on your team, they can implement it without needing a third party app. Additionally, the thread mentions that you can use Data Shuttle to solve the problem.
Hope this helps!
Nathan Braun (Founder of SSFeatures) (nathan@ssfeatures.com)
SSFeatures - The browser extension that adds more features into SmartSheet.
- Report PDF generator that supports grouped and summarized reports
- Automatic sorting, sorting with filters, saving sort settings
- Hiding and unhiding columns, and spell checking
Answers
-
Hi @sarahsfocused,
I believe that
is a third party application that might solve this problem. I have never used it before and I cannot vouch for it in anyway whatsoever.Other than that, I found this thread which seems similar to this one:
I don't think it's possible within SmartSheet at the moment. You can use the SmartSheet API, which is what DDUpdate does. The SmartSheet API is free, so if you have a coder on your team, they can implement it without needing a third party app. Additionally, the thread mentions that you can use Data Shuttle to solve the problem.
Hope this helps!
Nathan Braun (Founder of SSFeatures) (nathan@ssfeatures.com)
SSFeatures - The browser extension that adds more features into SmartSheet.
- Report PDF generator that supports grouped and summarized reports
- Automatic sorting, sorting with filters, saving sort settings
- Hiding and unhiding columns, and spell checking
-
Thank you @SSFeatures ! Slightly unfortunate, it seems like it should be pretty easy in other programs. But good to know what's possible now, and that people would like to see something like this in the future. Thanks for the response!
-
You're welcome, glad I could help!
Nathan Braun (Founder of SSFeatures) (nathan@ssfeatures.com)
SSFeatures - The browser extension that adds more features into SmartSheet.
- Report PDF generator that supports grouped and summarized reports
- Automatic sorting, sorting with filters, saving sort settings
- Hiding and unhiding columns, and spell checking
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 64.1K Get Help
- 414 Global Discussions
- 221 Industry Talk
- 459 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 141 Just for fun
- 58 Community Job Board
- 461 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 299 Events
- 38 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!