- nappalodgeAsked on August 23, 2017 at 04:43 AM
The spreadsheet widget is great and I can add up a list on calues in the right hand column and end up with a total in the bottom right hand cell. Can I use the value from this cell to feed into the form calulations widget, which is also great.
- CharlieAnswered on August 23, 2017 at 05:02 AM
However, you can use the "Input Table" widget to replicate the behavior in the Spreadsheet widget, you just need to use Conditional Logic to calculate the values in the cell. Then you can simply fetch the cell that holds the total calculation in the "Input Table" and insert it in a Form Calculation widget.
Below are two guides that might help you on how to accomplish this:
I hope that helps.