Copy Down adds functionality to Form-fed Google Sheets™ -- the ability to have row 2 formulas auto-copied into form submission rows.
By:
Listing updated:April 10, 2024
Works with:
37M+
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 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.
Additional information
PricingNot available
Developer
Non-trader
Support
Privacy policy
Terms of service
ReportFlag as inappropriate
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 :
View and manage your forms in Google Drive
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
See your primary Google Account email address
See your personal info, including any personal info you've made publicly available
Reviews
Language:
Sort by:
Google doesn't verify reviews or ratings. Learn more about reviews
Profile Picture
Jonathan Dick
September 12, 2024
love this extension... thank you for developing this it is incredibly helpful. I am however having an issue with multiple forms linked to the same google sheet... is this extension compatible?
Is this review helpful?
Yes
No
Profile Picture
Bhoopalan P
June 24, 2024
Copy Down is not working properly for past one week. Kindly look into the issue and resolve it as soon as possible
Is this review helpful?
Yes
No
Profile Picture
Ian Flores
May 20, 2024
What in the hell. When I activate it it looks for sheets that have now formula and ignores ones that do. I have two sheets with in one spreadsheet and it would even acknowledge the one Sheet I need it on. So dumb.
Is this review helpful?
Yes
No
Profile Picture
sumit Khanwalkar
October 2, 2023
Its a good plugin, best with its name but does not work as they say, It skips some random rows to update the formula, also several times it formats the formula cell to some random formatting, I need to check regularly if the it has copied all formulas or not.... tough the percentage of this is somewhere 7-8% only but its too random hence need to check it regularly, not disappointed but getting pissed due to error reporting.
Is this review helpful?
Yes
No
Profile Picture
Ravi Dogra
June 21, 2024
lunch or copy down setting not accessible, please resolve this as soon as possible
Is this review helpful?
Yes
No
Profile Picture
Jio Siddipet
June 24, 2024
It's not working
Is this review helpful?
Yes
No
Profile Picture
A User of Copy Down
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
Profile Picture
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
Profile Picture
CCS DailyCheckIn
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 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
1-10 of 40
Search
Clear search
Close search
Google apps
Main menu