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.
New Visions CloudLab
1,022,620 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
Diane Berthoin-Hernandez
August 14, 2016
Does not work!
Submit reply
Cancel
Mike Prill
January 8, 2017
Works great for moi.
Jonathan Harris-French
March 12, 2016
Fantastic add-on and very useful, I never seem to be able to pick up formulas in row 3, upwards?
Submit reply
Cancel
A User of Copy Down
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 user of Copy Down
March 24, 2017
I too experience intermittent issues with copydown. Fancy sharing your code?
A User of Copy Down
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
Kelly Hall
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
AFSE Robot
October 28, 2014
So fast. Thank you Andrew Stillman.
Submit reply
Cancel
1-6 of 6
Additional information
Search
Clear search
Close search
Google apps
Main menu