-
IDOEWebmasterAsked on June 22, 2016 at 2:20 PM
How do I multiply the value of column 1 and column 2 and show the result value in the column 3 of the matrix table?
Thanks.
-
BorisReplied on June 22, 2016 at 4:16 PM
If you want to perform calculations directly within a matrix, such as you would in an Excel spreadsheet, you will have to use our Spreadsheet widget instead of the Matrix field:
https://www.jotform.com/help/252-How-to-Add-a-Widget-to-your-Form
The Spreadsheet widget can perform calculations similar to those of traditional Excel spreadsheets or Google Spreadsheets:
Upon adding the Spreadsheet widget to your form, please add your desired calculations as "Default values" of the widget. If you need any further assistance in setting up the conditions, please let us know and we will be happy to help.