Google Product Forums
Re: How do I update formula for the rows that were just submitted to spreadsheed through form?
May 16, 2012 5:08 PM
Posted in group:
Sheets : Ask a "how-to" question : Desktop (specify browser/OS) :
they get deleted before form data is inserted, so I end up with A1, B1 filled in but G1 is empty.
As a matter of fact, your formulas are not deleted, but, since each new form-submission inserts a new row, they got shifted down to the next row.
= B1 - A1*9 +200
(You can use row 1 for your formula's; it should be the header row for the "Form sheet".
in cell G