How do I get a tabulated total out of the Spreadsheet Widget?

  • Profile Image
    MaggieJedlicka
    Asked on March 16, 2018 at 11:31 PM

    Hi Jotform,

    I have an EASY question. I'm doing something very simple. 

    I am adding 4 items in a column using the Spreadsheet Widget.

    The spreadsheet widget calculates it correctly. I'm using the FORM CALCULATION to get the total from the Spreadsheet widget, but it is not coming up correctly.

    Help!  I know this is easy!  What am I doing wrong???

    thanks in advance!

    Maggie Jedlicka

  • Profile Image
    Adrian
    Answered on March 17, 2018 at 09:36 AM

    Unfortunately, it is not possible to get a value from a specific field in the Spreadsheet Widget into the Form Calculation Widget.

    The form calculation widget will take all the values (as a string) and that is why the calculation is not coming up correctly.

    I have recreated your form using the Input Table element.

    DEMO: https://form.jotform.com/80753886311966

    You can select specific "cells" of the Input Table element when doing calculations.

    15212936971.png

    15212937392.png

    Feel free to clone my form and adjust it to your needs.

    How to Clone an Existing Form from a URL