-
LossuenosAsked on July 8, 2016 at 2:59 AM
Hi, we tried the exporting the spreadsheet file, but we have to do the manual calculations on the total value each time. is there a function where we can add "total values amount" on the exported spreadsheet on each column ?
can someone please advise?
example :
total no of participants = values
Total payable amount = values
total balance outstanding = values
total males = values
total females = values
many thanks, Lily
-
Chriistian Jotform SupportReplied on July 8, 2016 at 7:15 AM
You will need to have a calculation field in your form to compute for the total values of your form. You can just hide the field so user will not be able to see the field. You can check this article for more information: How to Perform Calculation in the Form. Once you have this field, it will also be included on the spreadsheet when you download the submission.
Do let us know if you need further assistance.
Regards. -
LossuenosReplied on July 13, 2016 at 5:50 AM
Thank you, will try again. Kind regards
-
LossuenosReplied on July 16, 2016 at 9:41 AM
Hi, as mentioned on earlier (other message) this one is only for single form entry..not on the exprted excel spreadsheet, I need the total value for each items. kindly advise. thanks.
-
Welvin Support Team LeadReplied on July 16, 2016 at 12:35 PM
It's not possible, unfortunately. You'd like to get the total of all the submissions which is stored in one column. As suggested by colleague Boris, you'll need to do it manually. That should take you a minute.
Here's a guide from MS Office: