Get total of all Grand Total fields in all forms into one Sheets using formula

  • Profile Image
    ravix15worldwide
    Asked on March 25, 2020 at 02: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

  • Profile Image
    Mike_G
    Answered on March 25, 2020 at 03: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.

    1585162221zt14_49_50.png

    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

    1585162347zt14_51_38.png

    1585163107zt15_03_38.png

    Here's how the formula would look like.

    1585163124zt15_03_56.png

    Result:

    1585163143zt15_04_33.png

  • Profile Image
    ravix15worldwide
    Answered on March 28, 2020 at 04:51 AM

    Dear Mike,

    Really appreciate your efforts for thr detailed illustration. I'm trying out the same

    Thanks and regards 

    Ravi

  • Profile Image
    roneet
    Answered on March 28, 2020 at 10:07 AM

    Do get back to us if you experience any inconvenience while setting this formula.

    Thanks.