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.

Step 1: Install the Copy Down add-on

Install the Copy Down Google Workspace 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

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