Automatically copy down formulas on Google form response submissions.
Automatically copy down formulas on Google form response submissions.
Add formulas in row 2 of your form submission sheet.
Open Copy Down, turn "On", select all formulas you wish to "copy down".