Embedded Files
How to automatically copy down formulas in Google Sheets receiving Google form responses?
You can automatically copy down formulas from row 2 of a Google sheet into the new rows created by Google form responses.
You can automatically copy down formulas from row 2 of a Google sheet into the new rows created by Google form responses.
Step 1: Install Copy Down add-on
Step 1: Install Copy Down add-on
Install Copy Down add-on from the Google Workspace Marketplace.
Step 2: Start Copy Down add-on in Google Sheets
Step 2: Start Copy Down add-on in Google Sheets
Click on Extensions > Copy Down > copyDown settings to open the Copy Down Formulas on Form Submit sidebar.Â
Step 3: Configure formulas to copy down
Step 3: Configure formulas to copy down
Change OFF to ON, so that all the formulas on row 2 are automatically discovered.
Select all the formulas in row 2 to be copied down into the new rows created by the Google form responses.
Click on Save settings.
Formulas are now copied to new rows created by Google form reponses.
Report abuse