-
sidncstAsked 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 SupportReplied 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.
-
sidncstReplied on April 29, 2024 at 10:35 PMTHese 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 SupportReplied 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:
Give it a try and let us know if you need any help.
-
sidncstReplied on April 30, 2024 at 2:10 AMhttps://form.jotform.com/241191426818054
this is the link.
... -
Chris_L JotForm SupportReplied 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:
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.