-
ChassityNeckersAsked 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.
-
Kiran Support Team LeadReplied 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!