Spreadsheet widget: How to perform calculation?

  • sidncst
    Asked on April 29, 2024 at 2:07 PM

    (D10/15)+(G10+H10+I10+J10+K10)*M8

    AND

    D10/15+G10+H10+I10+J10+K10*M8


    CANNOT GET THE SAME TOTAL AS THE SPREADSHEET SIMPLE CALCULATIONS



  • Carrissa JotForm Support
    Replied on April 29, 2024 at 3:28 PM

    Hi Sidney,

    Thanks for reaching out to Jotform Support. I'm sorry you're having issues with your Spreadsheet widget. Can you share with us how you want the form to work? If you can share with us a sample calculation, we can check how it can be set up.

    After we hear back from you, we’ll have a better idea of what’s going on and how to help.

  • sidncst
    Replied on April 29, 2024 at 10:35 PM
    THese are the 2 expressions and i am using these as a counter check to the
    basic spreadsheet formulated calculation that i am already using.
    Expression 1: (D10/15) + G10 + H10 + I10 + J10 + K10 * M8
    Expression 2: D10/15 + G10 + H10 + I10 + J10 + K10 * M8
    ...
  • Vanessa JotForm Support
    Replied on April 30, 2024 at 2:03 AM

    Hi Sidney,

    Thanks for reaching out to Jotform Support. Please provide more details on what you want to achieve. Where do you want to show the expression so we can check and see if that is possible?

    Here is a simple example of the Spreadsheet widget:

    Spreadsheet widget: How to perform calculation? Image 1 Screenshot 20

    Give it a try and let us know if you need any help.

  • sidncst
    Replied on April 30, 2024 at 2:10 AM
    https://form.jotform.com/241191426818054
    this is the link.
    ...
  • Chris_L JotForm Support
    Replied on April 30, 2024 at 5:05 AM

    Hi Sidney,

    Thanks for getting back to us. Please set the formula to R3 = ((D10/15)+(G10+H10+I10+J10+K10))*M8 and it should work. Take a look at screenshot below:

    Spreadsheet widget: How to perform calculation? Image 1 Screenshot 20

    Note that the value was rounded up to the nearest whole number. Here's the link to the cloned form.

    Reach out again if there’s anything else we can help you with.

 
Your Answer