Row 2 model guide

Use row 2 as the model for Google Forms response formulas

When a Google Form adds new response rows, formulas and formats do not always follow the way a normal spreadsheet table would. The safest FormCopy setup starts with one clean model row, usually row 2, then proves that pattern with one sample response.

Install FormCopy Open setup guide First-run checklist

Quick answer

Row 2 should contain the formula, formatting, helper-column, and status pattern you want future Google Forms response rows to inherit. Keep it clean, remove temporary values, and test one new submission before relying on a live sheet.

Use row-relative formulas

Formula references that should move with each response row need to point at the same row.

Lock shared ranges

Lookup tables, settings tabs, and fixed thresholds usually need absolute references.

Keep raw answers clean

Let Google Forms own the submitted response columns and place formulas in helper columns.

Submit one test

One sample response should create one new row with formulas, formats, and references copied correctly.

Prepare row 2

Open the linked Google Forms response sheet.
Put the formulas and formats you want to repeat into row 2 or another known-good source row.
Remove one-off notes, temporary overrides, stale formulas, and manual test values from that model row.
Check which references should move by row and which should stay fixed.
Install FormCopy and save the copy workflow for the response sheet.
Submit one sample form response and inspect the new row.

The first success metric is simple: the new response row receives the same helper formulas and formatting, while row-specific formulas now point at the new row.

When row 2 is a good model

Scoring formulas

Each response needs score, status, pass/fail, or reviewer formulas on the same row.

Helper columns

The response sheet has lookup, routing, assignment, or cleanup columns beside raw answers.

Formatting matters

Operators use row colors, number formats, validation, or visual cues while reviewing submissions.

Backfill is needed

Existing response rows already missed formulas and need the same model-row pattern applied.

If a single array formula can handle the whole column cleanly, you may not need row-by-row copying. Use FormCopy when each row needs formulas, formatting, helper logic, or controlled backfill from a model row.

After formulas copy correctly

If the new response row received the row 2 formulas and formatting correctly, use the review-after-success page or send setup feedback while the model-row result is fresh. Specific reviews help future operators understand what kind of sheet you tested.

Review after first success Send setup feedback Open Marketplace listing

Related FormCopy guides

Test formulas before launch Copy formulas to new responses Formulas not copying Helper columns Review after first success Permissions