Jotform Sheets: Insert formulas that are similar to Google Sheets and Excel

  • Profile Image
    AgilityAssoc.Canada
    Asked on January 18, 2020 at 03:57 PM

    Hi,

    I want to sum the values in a column in /sheets/81646514559970 

    I was looking at the math options and I couldn't figure out how to accomplish it>

    15793809032020-01-18 15_49_48-Window.png

    Can you demonstrate how this is done please.

    Thank you,
     Robert

  • Profile Image
    AgilityAssoc.Canada
    Answered on January 18, 2020 at 05:19 PM

    Hi 

    Something else I need to do is sum the number of courses submitted between two dates for two separate columns. Perhaps this image of a g-sheet calculation might help.

    15793859032020-01-18 17_01_13-Window.png


    Thanks,
      Robert

  • Profile Image
    Mike_G
    Answered on January 18, 2020 at 08:33 PM

    To my understanding, you are trying to add a column to create a formula that will sum all the values entered under the Courses column of the Sheets.

    1579397276zt20_26_20.png

    I would like to apologize for any inconvenience, however, I believe the formula is applied to values across each row, not per column. I'm afraid that you are trying to accomplish is not possible within the submissions sheets page. How would you like to consider downloading the Excel file of the submission and have the formula created there instead?

  • Profile Image
    AgilityAssoc.Canada
    Answered on January 19, 2020 at 08:48 AM

    Hi,

    This form is integrated with  G-sheets and this calculation is accomplished there.

    I do have a question about a calculation on G-sheets. I was hoping if you might explain the diff between two that do the same thing in a slightly different way and in some cases the result can be very different, but for the most part the the result is the same. 

    Are you willing and able to offer this support?

    Thank You,
     Robert

  • Profile Image
    VincentJay
    Answered on January 19, 2020 at 11:19 AM

    Hello,

    Are you willing and able to offer this support?

    We can try as long as it is still related to the Jotform issue. 


    Unfortunately, there's no option to add formula/calculation in the Jotform Sheets. If you want we can forward it and request it to our developers.



  • Profile Image
    AgilityAssoc.Canada
    Answered on January 19, 2020 at 11:50 AM
    Hi,

    Yes that would be extremely helpful if possible.
    I understand you cannot offer a completion date or if it will be accepted to do.

    As of now, I will be out of the office until next Thursday and will touch base about the calculations some time after that.

    Thank you,
    Robert. B. Cooper
    AAC IT/Forms Manager
    forms@aac.ca
    nationals.ca web manager
    brian@aacnationals.ca
    226.884.5272
    VE3TKC

    ...
  • Profile Image
    Mike_G
    Answered on January 19, 2020 at 01:08 PM

    On your behalf, I have forwarded this thread as a feature request to our developers to include a way to insert formulas into Jotform Sheets similar to the ones that can be inserted in Google Sheets and Excel.

    Although we cannot guarantee that this will be implemented anytime soon, please be assured that once there is an update we will notify you in this thread the soonest.