-
ravix15worldwideAsked on March 25, 2020 at 2:29 PM
I actually wanted the default values of Grand total of all sheets in an new column called Grand Total All
Which is grand total 1+2+3+4+5= Grand Total All
Where in it shows all the grand total values and totals up
Else even if it totals up in original column of grand total is also fine
But I'm unable to place the formula
Thanks
-
Mike_G JotForm SupportReplied on March 25, 2020 at 3:06 PM
I understand that you are getting the total of the Grand Total fields in all of your form's Sheets into one of your forms' Sheets.
That would be possible using Formula. You may need to connect each Grand Total field in the other forms to the Sheets you would like it to appear. In this case, each Grand Total field from the different forms will have its own column in the (main) Sheets.
After that, you will add the value of each Grand Total field column which data are from different forms into another column — Grand Total ALL using formula
Here's how the formula would look like.
Result:
-
ravix15worldwideReplied on March 28, 2020 at 4:51 AM
Dear Mike,
Really appreciate your efforts for thr detailed illustration. I'm trying out the same
Thanks and regards
Ravi
-
roneetReplied on March 28, 2020 at 10:07 AM
Do get back to us if you experience any inconvenience while setting this formula.
Thanks.