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 essential features into Smartsheet.
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 essential features into Smartsheet.
-
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 essential features into Smartsheet.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 66.2K Get Help
- 431 Global Discussions
- 152 Industry Talk
- 490 Announcements
- 5.2K Ideas & Feature Requests
- 85 Brandfolder
- 155 Just for fun
- 74 Community Job Board
- 501 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 306 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!