How to use Calculation widget to calculate a column from Spreadsheet widget?

  • Profile Image
    ChassityNeckers
    Asked on August 19, 2019 at 10:47 AM

    Hello,


    Has anyone tried to get the calculation widget to calculate one column within a spreadsheet? For example, I am wanting the user to enter sources of income on one column and the amount in another using the spreadsheet widget. However, I am having a hard time figuring out if it is possible to have the calculation widget sum up the amount column. 

  • Profile Image
    Kiran
    Answered on August 19, 2019 at 12:03 PM

    Unfortunately, reading a specific column data from Spreadsheet widget is not possible. However, you may perform the calculation within the spreadsheet widget only. You may try using Input Table field so that you may use a calculation widget to read specific field values. Please see the guide below:

    https://www.jotform.com/help/414-Calculate-Values-in-the-Input-Table-Through-Condition

    Hope this information helps!