Google Product Forums
How do I update formula for the rows that were just submitted to spreadsheed through form?
Sergio9 May 16, 2012 1:10 PM
Posted in group: Google Docs

Categories: Sheets : Ask a "how-to" question : Desktop (specify browser/OS) :

I have a spreadsheet.
3 columns are submitted, and 4 are just formulas for current row (e.g. G1 = B1 - A1*9 +200,  G2 = B2 - A2*9 +200 etc)
How do I set up google spreadsheet to fill in these formulas automatically for each newly submitted row?

The problem right now is that even if I had formulas pre-defined - they get deleted before form data is inserted, so I end up with A1, B1 filled in but G1 is empty.
Is there a simple way to fix it?
(except some crazy ways like writing a script that will add formulas etc)

Thanks