- kffdnAsked on November 05, 2014 at 12:33 PM
When I have multiple check boxes to answer 1 question, when I export to excel all the answers (the boxes that were checked) are pushed together with no delimiter all in one column. Is there a way to have each checked box appear in it's own column or to have a delimiter placed between values in the one column?
If they choose A,C and D, the value in the excel column 'what options' is ACD. and I need to count the number or AS, Bs, etc in the whole worksheet.
Thanks for any advice!
- BenAnswered on November 05, 2014 at 01:04 PM
I would recommend using Grid Listing report: How to create a Grid Listing report
It should be showing the values differently for you.
Could you please also tell us which jotform is this happening on please since I see that you have over 60 of them?
Also can you please tell us a few more details, such as should they only choose one option or several of them and if you use these values somewhere in the jotform?