Help & Support
Send Feedback
copyDown adds functionality to Form-fed Google Sheets -- the ability to have row 2 formulas auto-copied into form submission rows.
New Visions CloudLab
1,017,541 users
Works with
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

formMule - Email Merge Utility Add-on
Does not work!
Submit reply
January 8, 2017
Works great for moi.
Fantastic add-on and very useful, I never seem to be able to pick up formulas in row 3, upwards?
Submit reply
December 15, 2015
When it works, it works great. However it worked inconsistently for me. It would occasionally stop working, and sometimes I could fix it by turning it off and back on, and sometimes it wouldn't turn back on except by a fluke (it even turned itself back on after I finally got frustrated and turned it off). It also used to work for additional (not form-driven) rows on the tab, but this stopped working a while back. I wrote a code myself to accomplish the same thing with better consistency.
Submit reply
A Google User
March 24, 2017
I too experience intermittent issues with copydown. Fancy sharing your code?
June 10, 2015
i like it! but it only works for the first 200 rows?
Submit reply
February 26, 2015
Doesn't support spreadsheets with multiple forms attached. Cannot change the origin/destination sheet where the copy-down occurs. Otherwise, this is a great add on. I love everything that New Visions does.
Submit reply
January 15, 2015
Oh my head...this is Brilliant! I have been searching in vain for a way to have a formula be applied to each Form submission and THIS IS IT. Super easy to use - love the "slider" off/on button.
Submit reply
October 28, 2014
So fast. Thank you Andrew Stillman.
Submit reply
1-7 of 7
Additional information
Clear search
Close search
Google apps
Main menu