Splitting form data from multi-select field into multiple columns on sheet
Options
Kyle Wefler
✭✭
I am trying to use SmartSheet to send out a form to vendors that allows them to select choices in a Multi-Select field. I then need to have the choices the vendors selected in the multi-select field split out into a binary type of indicator on multiple columns in the SmartSheet in order to use the data in a meaningful way. Does anybody know of any functionality or formula that might be able to help with this? Thanks!
Answers
-
THIS THREAD has a parsing solution similar to what you are looking for. Feel free to take a look and let me know if you would like some help adapting it to your particular needs.
Help Article Resources
Categories
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!