Form/Sheet Question

meganrold

I've created a form with a dropdown menu list. Once I fill the form out and submit it, all of the multiple options I've selected appear on one line in the sheet. Is there a way to get each option selected in the dropbox menu to then be on its own separate line when populated into the sheet? We have several different partners that our content need to go to, and it's difficult when all of the partners are clumped together on a single line.

I want all of the items/partners below to have their own separate lines. So, Apple would appear on line 1, Google on line 2 and Peacock on line 3. Is there a way to do this?

Kerry St. Thomas

At its root, a form is for collecting data. Each time "Submit" is collected on the form, ONE row of data will be captured. So your basic options are to either go with what you have now, or set up the column as a single select (requiring users to submit info 3 times).

There is an excellent post here outlining a solution to a similar problem. It is, however, kind of a bear to set up initially - and the longer your form is, the less scalable this is. But it's still definitely a place to explore.

https://community.smartsheet.com/discussion/119380/split-multiple-selections-in-single-form-into-individual-rows-core-product

Good luck!