Help & Support
Send Feedback
Copy Down
Copy Down adds functionality to Form-fed Google Sheets -- the ability to have row 2 formulas auto-copied into form submission rows.
2,065,988 users
Works with
Install
Overview
copyDown adds a simple but revolutionary functionality to Google-Form-fed Google Sheets -- the ability to have formulas and cell formats carry into new form submission rows.

With this ability, any Google form submission can auto-calculate subtotals, perform a vertical lookup against another sheet, include conditional formats or data-validation lists in new form rows, or calculate a count or countif tied to a cutoff threshold -- and these are just a few examples -- don't get us started!

Use in combination with the autoCrat or formMule Add-ons for Sheets to bring calculated values and formatted numbers and dates into your form-triggered document and email merges.

IMPORTANT:  Due to limitations of Apps Script, copyDown is NOT COMPATIBLE WITH SPREADSHEET FILTERS on the form response sheet.

Learn more about...

autoCrat Add-on
http://cloudlab.newvisions.org/add-ons/autocrat

formMule - Email Merge Utility Add-on
http://cloudlab.newvisions.org/add-ons/formmule-email-merge-utility
Reviews
A User of Copy Down
January 10, 2020
DIsapointed that all I have now is a spinning wheel
Submit reply
Cancel
A user of Copy Down
January 13, 2020
OPPO A33f
A User of Copy Down
December 15, 2019
Has always worked well and I love it! But it is not working tonight. The wheel is just spinning. Does not progress from the "on" button to finding formulas and doing what it is supposed to do. Have never had problems before today, literally.
Submit reply
Cancel
A user of Copy Down
January 13, 2020
OPPO A33f
Anastasia Luettecke
November 15, 2019
Many, many times this add-on refuses to work, requiring resetting. Its instability makes it difficult to keep the spreadsheet running smoothly.
Submit reply
Cancel
A User of Copy Down
October 25, 2019
Was working great until recently? Spinning wheel!
Submit reply
Cancel
A User of Copy Down
September 17, 2019
I'm new to google forms/sheets so my assumption it would work pretty much like excel, I was bummed when my formulas that I created to supplement the form data were changing....... I'm not sure how I finally came across copy down - probably googled "formulas keep changing in google sheets". Copy down was the answer to my issues. Lifesaver!
Submit reply
Cancel
A User of Copy Down
April 2, 2019
This is what I have been looking for! Very Helpful!
Submit reply
Cancel
A user of Copy Down
September 14, 2019
is there a way we can have it work with a sheet with multiple forms, because at times you have 2 forms with data on the same sheet, ? Now copydwn will only apply to the first one and cannot work on the others thank you
A User of Copy Down
August 21, 2018
Helps a ton to push formulas to new submissions.
Submit reply
Cancel
A User of Copy Down
January 17, 2018
I use it daily at my job and the only time it messed up was when they updated the program and I guess the old version stopped working.
Submit reply
Cancel
A User of Copy Down
November 8, 2017
The new banner hides the functions
Submit reply
Cancel
MWOG REQUEST
November 8, 2017
Please help restore the save button and help restore CopyDown tool the same way it has always being. This tool is great....
Jun Espinosa
November 7, 2017
Hi Cloudlab, after the update yesterday. the save setting button is covered by your banner image. I can't save the setting's for paste value only.. Please rectify this issue.. Thanks for this Extension this helps me alot.. Regards
Submit reply
Cancel
MOHAMED ELHASSAN
December 7, 2017
Same here too.
A user of Copy Down
November 9, 2017
same issue
A user of Copy Down
November 8, 2017
Same issue here
1-10 of 17
Additional information
Search
Clear search
Close search
Google apps
Main menu