How to separate check box selections in excel spreadsheet report
-
drwilburneAsked on September 26, 2016 at 10:32 AM
Is it possible for the excel spreadsheet to separate selections with a comma when a user submits an answer with more than on answer? Example: Please select all counties that you serve. Mifflin, Juniata, Dauphin, Philadelphia, etc...
This is a re-post of a comment on How to Create an Excel Report
-
IrshadAnswered on September 26, 2016 at 12:20 PM
The selected options are wrap in the excel report by default. Please check the screenshot below:
If the above output won't work for you, please try using our asmSelect Widget: http://widgets.jotform.com/widget/asmselect. This widget will give you a comma separated values.
Here's -How-to-Add-a-Widget-to-your-Form.
If you have any query, or need further assistance, feel free to revert back.
Thanks.