New Visions Cloudlab
•  2,831,888
Overview
Copy Down adds functionality to Form-fed Google Sheets -- the ability to have row 2 formulas auto-copied into form submission rows.
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
Language:
Sort by:
A User of Copy Down
March 16, 2020
good app
Is this review helpful?
Yes
No
A User of Copy Down
March 12, 2020
You guys should change the name from 'copy down' to 'spin around' or 'wheel of misfortune' because that's frankly all I ever see. You could even add a puzzle to solve and turn each spoke of the pinwheel into a prize. That would be so awesome. I'd give you 5 stars for sure if you did that.
Is this review helpful?
Yes
No
A user of Copy Down
March 25, 2020
You should ask for your money back.
Ernest Heisten
March 6, 2020
The program is very helpful and serves a great need. I find, however, I have to constantly check that it is, in fact, applying the formulas to all submissions . It's not always stable and seems to drop formulas in an unpredictable way. So I regularly need to go into the form responses and manually apply the formulas to be sure the most recent submissions apply the formulas that the time sensitive emails, that depend on the this program, are generated.
Is this review helpful?
Yes
No
A User of Copy Down
January 10, 2020
DIsapointed that all I have now is a spinning wheel
Is this review helpful?
Yes
No
A user of Copy Down
January 13, 2020
OPPO A33f
A User of Copy Down
December 15, 2019
Has always worked well and I love it! But it is not working tonight. The wheel is just spinning. Does not progress from the "on" button to finding formulas and doing what it is supposed to do. Have never had problems before today, literally.
Is this review helpful?
Yes
No
A user of Copy Down
January 13, 2020
OPPO A33f
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.
Is this review helpful?
Yes
No
A user of Copy Down
March 30, 2020
hu
A User of Copy Down
October 25, 2019
Was working great until recently? Spinning wheel!
Is this review helpful?
Yes
No
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
A User of Copy Down
April 2, 2019
This is what I have been looking for! Very Helpful!
Is this review helpful?
Yes
No
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.
Is this review helpful?
Yes
No
1-10 of 20
Additional information
New Visions Cloudlab
Support
Terms of Service
Search
Clear search
Close search
Google apps
Main menu