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.
1,856,126 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
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
Julianna Dempsey
September 30, 2017
Love this concept. For some reason it doesn't always work... depends on the form.
Submit reply
Cancel
David Hansen
July 5, 2017
Works on some rows and some not. Says that it copied but didn't
Submit reply
Cancel
A user of Copy Down
May 22, 2019
same issue
1-10 of 16
Additional information
Search
Clear search
Close search
Google apps
Main menu