JotForm is a free online form builder which helps you create online forms without writing a single line of code. No sign-up required.
We believe that if one user has a question, there could be more users who may have the same question. This is why many of our support forum threads are public and available to be searched and viewed. If you’d like help immediately, feel free to search for a similar question, or submit your question or concern.
How can I have check box answers in separate columns in Excel.Asked by naccc on August 10, 2015 at 10:54 AM
In the survey below, Question 10 allows multiple options to be checked.
If I select more than 1 and then export the submissions into an excel spreadsheet all the selected options for this question are in the same column.
What I would like to do is for these type of questions there is a separate column for each option which contains the option name if selected and is blank if that option is not selected.
This way I can count the number of people who have selected a particular option.
Is there a way I can do this in the form Design?
I think I have explained it in the attached screenshot but happy to provide more info if needed.
Unfortunately, that's not possible with Jotform. However, you can do that over excel as I have explained on this thread. This should help. If you have further questions or if you need clarifications about this, feel free to post it here.
"Keeping children in touch with parents following separation"
[cid:image002.jpg@01D0D4EB.9AC83700] www.naccc.org.uk [cid:image003.jpg@01D0D4EB.9AC83700] Like Us [cid:image004.jpg@01D0D4EB.9AC83700] Follow Us
Head office: 1 Heritage Mews, High Pavement, Nottingham, NG1 1HN Tel: 0845 4500 280 (Calls will cost 2p per minute plus your telephone company's access charge) or 0115 948 4557
NACCC is a Company Limited by Guarantee No. 3886023 (Registered in England and Wales). Registered Charity No 1078636.
This email (and any attachments) is confidential and may contain personal views, which are not the views of NACCC unless specifically stated. If you have received it in error, please delete it from your system, do not use, copy or disclose the information in any way nor act in reliance on it and notify the sender immediately. Please note that NACCC monitors e-mails sent or received. Further communication will signify your consent. Please consider the environment and think before you print this email.