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

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!