-
nancytorrisonAsked on March 19, 2019 at 2:48 PM
How do I create a grand total using multiple spreadsheet widgets and multiple column totals? I have a budget worksheet that uses 6 separate spreadsheet widgets and I want to get a total of all Year 1 Budget requests and all Year 2 budget requests and show that as an automatic calculation within a final Total spreadsheet.
Thank you!
-
Nik_CReplied on March 19, 2019 at 4:54 PM
I'm afraid that you cannot total multiple Spreadsheet widgets, since widgets are acting as a separate iframe in form so you cannot extract data from it.
But you could do something similar with the input table field:
If you create it in a similar way as you did with the Spreadsheet you will be able to extract total.
Let us know if you have any further questions.
Thank you!