Capture data in different columns

Lizbet

I would like to be able to separate the options of a multiple type column into different columns, for example, if a drop-down list with multiple selection "Texas", "New York", "North Carolina", "South Carolina" can be placed in the column ", then I would like to be able to have those three words recorded in different columns. Or even from a form, if a person wants to register the work centers where he works, he would like him to first register the first work center after being asked, Do you work in more than one work center? If the answer is yes, another box is enabled to select the name of the second and so on if there were more. I have tried to do this with formulas and also with automation flows but I have not succeeded, I would appreciate if someone could help me, thanks.

Paul Newcome

You would need to include as many individual columns as you would need to allow for selections in the sheet itself as well as a column that asks the user to enter the total number. Then you would add all of those fields to the form and set up the form logic so that if the user enters 1 then only 1 work center field is shown, if the user enters 2 then 2 fields are shown, so on and so forth.

Lizbet

Hi Paul,

I thought about that but how could I automate it in the form so that 1 field comes out of the user indicating it, 2. 3, 4 if necessary because I can't find that columns can be added in automation, do you have any idea how to configure that automation logic ?

Paul Newcome

It is in the form builder itself. You would use field logic. It is not an automation.

Lizbet

Could you show me how you would configure it in the form under the logic that you propose? I have tried to do it directly from the form but I have not been able to make the field where the user indicates their work center be linked to the fields that are enabled to be filled. Please, if you can take a screenshot of your configuration, it would help me a lot

Andrée Starå

Hi @Lizbet

I hope you're well and safe!

To add to Paul's excellent advice/answer.

More info.

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

Did 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 or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

Lizbet

Thank you very much, that was very valuable for me!

Andrée Starå

@Lizbet

Excellent!

Happy to help!

✅Please support the Community by marking the post(s) that helped or answered your question or solved your problem with the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!