Split Multiple Selections In Single Form Into Individual Rows (Core Product)

Paul Newcome

@NeilKY The [Option] column should have the formula in rows 1 - 10 and no other rows at all. The [Copy Section] column should also only be checked in rows 1 - 10.

NeilKY

https://community.smartsheet.com/discussion/comment/462310#Comment_462310

Sounds good. I'm still totally confused as to how it works though :) Can I ask a few clarifying questions?

1. In the form: Which fields do I want to have in the form and which ones should be hidden and which are for values users input?
2. In the form sheet, is there any particular order and column I should be sorting the sheet? it seems to give different results based on which data comes first. For example, if the "Copy section" contains the 10 rows that are checked in 1:10, then the "Option" column doesn't populate.
3. Can you explain in layman's terms, what the sheet is doing so I can get a better grasp of it?

 Thanks again! I sure hope i can get this to work.

spirucki

Hi Paul, I am getting stuck on how to make the solutions run automatically as new forms are submitted. I was able to duplicate yours based on the instructions you provided. But it only created it for the first row.