App Icon
Copy Down adds functionality to Form-fed Google Sheets -- the ability to have row 2 formulas auto-copied into form submission rows.
Works with:
10,000,000+
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
Additional information
SupportNot available
Privacy policy
Terms of service
Copy Down will ask for the permissions shown below. Learn more
Copy Down will need access to your Google account
This will allow Copy Down to :
See, edit, create, and delete all of your Google Drive files
See, edit, create, and delete all your Google Sheets spreadsheets
Connect to an external service
Allow this application to run when you are not present
Send email as you
View and manage data associated with the application
View and manage your forms in Google Drive
See your primary Google Account email address
See your personal info, including any personal info you've made publicly available
Reviews
Language:
Sort by:
Profile Picture
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.
Is this review helpful?
Yes
No
Profile Picture
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
Is this review helpful?
Yes
No
Profile Picture
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.
Is this review helpful?
Yes
No
Profile Picture
Julianna Dempsey
September 30, 2017
Love this concept. For some reason it doesn't always work... depends on the form.
Is this review helpful?
Yes
No
Profile Picture
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!
Is this review helpful?
Yes
No
Profile Picture
A User of Copy Down
April 2, 2019
This is what I have been looking for! Very Helpful!
Is this review helpful?
Yes
No
Profile Picture
Diane Berthoin-Hernandez
August 14, 2016
Does not work!
Is this review helpful?
Yes
No
Profile Picture
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?
Is this review helpful?
Yes
No
Profile Picture
David Hansen
July 5, 2017
Works on some rows and some not. Says that it copied but didn't
Is this review helpful?
Yes
No
Profile Picture
A User of Copy Down
November 8, 2017
The new banner hides the functions
Is this review helpful?
Yes
No
1-10 of 37
Search
Clear search
Close search
Google apps
Main menu