Help & Support
Send Feedback
copyDown
copyDown adds functionality to Form-fed Google Sheets -- the ability to have row 2 formulas auto-copied into form submission rows.
750,664 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
Does not work!
Submit reply
Cancel
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
Cancel
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
Cancel
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
Cancel
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
Cancel
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
Cancel
October 28, 2014
So fast. Thank you Andrew Stillman.
Submit reply
Cancel
1-7 of 7
Additional information
Search
Clear search
Close search
Google apps
Main menu