App Icon
New Visions Cloudlab
•  3,268,515
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:
Profile Picture
A User of Copy Down
October 8, 2020
good support
Is this review helpful?
Yes
No
Profile Picture
A User of Copy Down
September 26, 2020
Good
Is this review helpful?
Yes
No
Profile Picture
A User of Copy Down
September 25, 2020
weird but cool
Is this review helpful?
Yes
No
Profile Picture
A User of Copy Down
September 17, 2020
It's great...when it works. CopyDown provides a solution for a very common problem. The only issue is that it does not always work properly. For some reason, it skips rows randomly and won't paste the formulas there. Disappointed that there seems to be no reasoning for or solution to this problem. Going to try something different instead.
Is this review helpful?
Yes
No
Profile Pciture
A user of Copy Down
September 28, 2020
I think this happens when you sort the rows by other columns different from the TimeStamp Column
Profile Picture
A User of Copy Down
September 13, 2020
Very good
Is this review helpful?
Yes
No
Profile Picture
A User of Copy Down
August 6, 2020
Copy Down Add on not highlighted in Google Sheet. Whats the issue?
Is this review helpful?
Yes
No
Profile Picture
A User of Copy Down
July 28, 2020
Just stopped working and now all I have in a spinning wheel
Is this review helpful?
Yes
No
Profile Picture
Adam Sawicki
July 17, 2020
Great when it works. Will just stop functioning and need to be reset. Pretty bad as their is no indication that it stopped unless you manually look as the add on still says "on"
Is this review helpful?
Yes
No
Profile Picture
Michael Fricano
June 26, 2020
It works as expected with automatically copying formulas down the column, but I'm seeing some unusual formatting issues with the spreadsheet after using Copy Down. Some cells become bold, other cells fill color or text color gets changed. And sporadically the Timestamp column format is changed to some long number with a decimal.
Is this review helpful?
Yes
No
Profile Picture
A User of Copy Down
June 18, 2020
Dear expert Im having serious issue with this addon .. it's difficult to explain .. but I could share a video of what's happening but not sure how to link it back to this page. Suggestions.?? Stuart
Is this review helpful?
Yes
No
1-10 of 30
Additional information
New Visions Cloudlab
Terms of Service
Search
Clear search
Close search
Google apps
Main menu