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 a way to customize the excel spreadsheet to tally what colums were selected?

    Asked by ryanbetzler on July 03, 2014 at 02:15 PM

    Hello,

     

    Is there a way to customize the excel sheet produced by jotform which not only has a column for which item was selected, but also places a 1 value for the selected item.

     

    For Ex:  (reference screengrab)  If a user selects Golf + Dinner, can the spreadsheet add a 1 to both a Golf column and a 1 do the Dinner column.   Our goal is to be able to tally how many people will attend dinner, and also golf.

     

    Note: This field is found multiple times throughout the same form as to accommodate for additional registrants.

     

    Thank you for your assistance! 

     

    - Ryan

    Page URL:
    www.beagleopen.org

    Screenshot
    excel selected tally JotForm assistance
  • Profile Image
    JotForm Support

    Answered by EltonCris on July 03, 2014 at 03:03 PM

    Hi,

    Sorry but that is not possible with Jotform reports as of the moment.

    However, you can achieve that when you download your form submissions to Excel. 

    How-to-Download-Form-Submissions-to-Excel-CSV-PDF

    And then open the file to your Excel program and count each option by using the following formula.

    =COUNTIF(A1:A14,"*text*")

    A1:A14 - is the range you want to search the text

    *text* - replace text with the text you want to search. The asterisk means search any text that starts or ends with text.

    If you need further clarification, let us know here.

    Thanks!