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

    How to add formula to Spreadsheet widget?

    Asked by HOWNewForms on May 25, 2015 at 10:22 PM
    Still need to work on the calculations.  I've tried both the Excel formula (Column/Row d1 "=b1*C1") and Mike G's formula in earlier response of d1 = b1*c1 and neither get saved.

     http://www.jotform.com//?formID=51438935402152

    Will spend some time this evening.

  • Profile Image

    Answered by Carina on May 25, 2015 at 10:27 PM

    I inspected the form and the Spreadsheet didn't have any default values (formula) added:

    To add a formula to this widget please select the wizard and then add the formula to the "default values" area as seen bellow: 

    Formula

    d1 = b1*c1

    d2 = b2*c2

    d3 = b3*c3

    d4 = b4*c4

    d5 = b5*c5

    d6 = b6*c6

    d7 = b7*c7

    d8 = b8*c8

    d9 = b9*c9

    d10 = b10*c10

    d11 = b11*c11

    d12 = b12*c12

     

    d13 = d1+d2+d3+d4+d5+d6+d7+d8+d9+d10+d11+d12

    You can test and clone  the demo form:

    http://form.jotformpro.com/form/51448663760966? 

    Let us know if we can assist you further.   

  • Profile Image

    Answered by George Chrisman on May 25, 2015 at 11:03 PM

    Thanks for the solution.  I read the box as "Optional" and never saw a notice that default values had to be applied.

  • Profile Image
    JotForm Support

    Answered by ashwin_d on May 26, 2015 at 01:02 AM

    Helo George,

    On behalf of my colleague, you are welcome.

    Yes the "Default Values" property of the "Spreadsheet" widget is optional but needs to be added if you need to display or add some calculation formula.

    Do get back to us if you have any questions.

    Thank you!