What is JotForm?
JotForm is a free online form builder which helps you create online forms without writing a single line of code. No sign-up required.

At JotForm, we want to make sure that you’re getting the online form builder help that you need. Our friendly customer support team is available 24/7.

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.

  • Profile Image

    Is there any way to get the multiple results of the check box to be shown in individual excel cells?

    Asked by lauratibbs on January 24, 2012 at 07:21 AM

    I have a check box in my servey with 20 potential tick box options. When someone ticks more than one option, which is often necessary, the results in the excel report are all shown in one collumn in one cell. Is there any way to get the results to show in one cell for each tick box selected. This will make processing the data a lot easier. 

  • Profile Image

    Answered by fxr on January 24, 2012 at 05:23 PM

    No, unfortunately it is not possible to split the response up over multiple cells, but you could use a formula like this on your excel sheet to count the responses of a specific response. 

    e,g if you a looking to count all cells that contain the text/response 'Children' in row B of your spreadsheet, enter the following into a spare cell. 

    =COUNTIF(B:B,"*" & "Children" & "*")

    You can do that for all your possible options and should make processing of your data that little bit easier.

    Does that help?