To use ArrayFormula on the spreadsheet collecting responses:
1. Insert a column on your spreadsheet (1) that will be used to calculate the grand total
2. Submit your Form once (2). This will create a line on your spreadsheet
3. Insert a row above your Form submission
4. Add your arrayFormula in the row you have inserted, under the column header that will be used to calculate the grand total.
Here we will use=ARRAYFORMULA(C2:C20*D2:D20) or Total=Price*Qty
5.Start collecting form responses. The grand total will be calculated on your spreadsheet, under the column header you have inserted.
Reviewers will receive this Total in the Request for approval email and it will display in the Approval Form the reviewer will review. If you do not want this column to show in the Approval Form the reviewer will review add the pre-fix FW to the column header. Eg. Total will become FW Total.
Decline the 1st form submission that was used to create a line on your spreadsheet (cf. point 2. above)