If a one submission on an intake form has a multiple selection question/field, can it be separated?

Wen H.

I have been requested to update one of our intake forms, so far all questions are single-select and it represents a single row on the sheet but the update intel's making some of the questions multiple-select. The selections represent training that require scheduling and I wanted to confirm if there was an option to breakdown one submission into several rows.

Andrée Starå

Hi @Wen H.

I hope you're well and safe!

My method below is the simplest way, but it's also possible to have multiple rows automatically created, but it's pretty advanced.

I developed a solution using two forms (or the same form by using conditional logic) that can be used to submit the main information and then the other information on a new row for each submission after the first.

Would that work/help?

I hope that helps!

Be safe, and have a fantastic week!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up, Awesome, or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

Wen H.

Thank you!

Where do you build this conditional logic? Or is it an automation to move the rows into a sheet?

Within the form, logic only allows to format what fields to show.

Andrée Starå

@Wen H.

Happy to help!

The Conditional Logic is a feature in forms.

https://help.smartsheet.com/articles/2481701-use-conditional-logic-to-streamline-form-submissions

I'd be happy to share an example. 

Please email me at andree@workbold.com, and I'll share it with you.

✅Remember! Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up/Awesome or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

Wen H.

I already use this feature heavily 😀, but this link gave me access to other articles that may keep the ideas flowing. Thank you!

Andrée Starå

@Wen H.

Excellent!

Happy to help!

✅Remember! Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up/Awesome or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!