Is there a way to customize the excel spreadsheet to tally what colums were selected?

  • Profile Image
    ryanbetzler
    Asked 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

  • Profile Image
    EltonCris
    Answered 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!