Copy Down Formulas
How to automatically copy down formulas in Form-fed Google Sheets?
When a new Google Form response is submitted you can automatically copy down formulas from row 2 of your Google Sheet into the newly form submission rows.
When a new Google Form response is submitted you can automatically copy down formulas from row 2 of your Google Sheet into the newly form submission rows.
Step 1: Install the Copy Down add-on
Step 1: Install the Copy Down add-on
Install the Copy Down Google Workspace add-on
Step 2: Start the Copy Down add-on
Step 2: Start the Copy Down add-on
Start configuring which formulas you want to copy down by clicking on Extensions > Copy Down > copyDown settings. A new sidebar will open.Â
Step 3: Configure which Formulas to Copy Down
Step 3: Configure which Formulas to Copy Down
Turn the switch from OFF to ON. All formulas on row 2 will be automatically discovered.
Select all to select all formulas in row 2 to be copied down to the new rows created by a Google Forms response.
Click Save settings
That's it. You are good to go. Any new rows created by a Google Forms reponse will have their formulas copied to them
Sample Google Docs Template for mail merge purpose