Media Gallery
About this addon
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.
Metrics Progress
Track how this addon's metrics have evolved over time