When a Google Form writes into a linked response sheet, formulas may appear to skip new rows, leave helper cells blank, or change references after each submission. The fix is usually to separate raw response columns from a clean formula model row, then test how formulas behave when copied into a fresh response row.
If formulas are skipping rows in a Google Forms response sheet, check whether Google Forms is inserting new rows below your formulas, whether the formula uses hard-coded references, and whether the formula should be an array formula or a row-by-row copy. For row-specific formulas, keep one clean model row and copy that pattern into each new response row.
Your formula may be sitting below the response area, or the new form row may not inherit formulas from nearby cells.
The formula may contain relative references that were copied from the wrong row, or fixed references that should not move.
The linked response sheet is controlled by Google Forms. Each submission is inserted as response data first; spreadsheet formulas and formatting around that data need their own pattern.
New submissions do not always behave like someone typed into the next line of a normal spreadsheet table.
Pre-filled formulas below the response area may be pushed down, left behind, or disconnected from the new response row.
Operational sheets often contain lookup, score, status, or routing columns that need to stay aligned with the response row.
If the copied row contains temporary overrides, notes, or stale formulas, those mistakes can repeat across later rows.
A formula that looks correct in row 2 can become wrong if it mixes relative and absolute references without a clear intention.
A row 5 formula that evaluates row 5 data should usually reference cells such as E5, not E3.
Thresholds, lookup tables, and constants often belong on another sheet or in fixed ranges such as $K$2.
Let Google Forms own the submitted answer columns. Put formulas in helper columns to the right or in a dedicated processing sheet.
Manually adding a row is not always the same as a real Google Forms submission. Use one real test response before launch.
Usually row 2, or the first complete row that contains the exact formulas and formats you want future rows to inherit.
Confirm row formulas point to the same row and setting formulas point to fixed ranges or lookup tabs.
Verify the new row receives formulas, formats, helper-column values, and row references that match the new row number.
For simple derived columns, one array formula in the header or first formula row can be cleaner than copying formulas into every row.
Simple calculations, text cleanup, date formatting, and logic that can evaluate an entire column consistently.
Complex row formatting, mixed formulas, manual status columns, per-row validation, and workflows where existing rows need controlled backfill.
FormCopy is useful when the response sheet has row-specific formulas or formatting that should be copied from a known good model row into future or existing response rows.
Remove temporary notes, copied errors, and stale calculations before using a row as the source pattern.
Use relative references for same-row response values, and absolute references for constants or lookup ranges.
Keep Google Forms answer columns clean; put formulas in helper columns or a processing tab.
A real form submission is the only reliable check that the setup matches how Google Forms inserts rows.
Usually the sheet has a mixed history: some rows were manually fixed, some were inserted by Google Forms, and some formulas were dragged from a different source row. Normalize the model row, then retest on one new submission.
You can for small, low-risk sheets, but it is fragile. Submissions can still land in ways that leave helper cells blank, and it is easy to drag a formula pattern that later proves wrong.
Both can work. Keep the response tab simple when possible; use helper columns or a processing tab if formulas are complex or if multiple people edit the sheet.
Yes, use backfill after the source row has been checked. Start with a small range or copied spreadsheet if the file is important.