Used in conjunction with formMule and autoCrat, this Add-On allows users to apply formulas to form response submissions as they are received; this allows for powerful, more personalized mail merges!
CREATE AND DETECT FORMULAS
Add formulas to row in spreadsheet (we suggest row 2). Once you select copyDown from your Add-Ons menu, a sidebar will open with a simple "On / Off" switch. Switch to "On", select row containing formulas, and select all formulas you wish to copy down.
OPTIONALLY PASTE FORMULAS AS VALUES
Before saving and closing the sidebar you can select which of your formulas to paste back into the sheet as values. This has the same effect as the "paste as values" option you may use in Sheets; this option eliminates formulas once they have calculated, leaving only the formula calculation value in each cell. Less calculations = a faster spreadsheet!