FormCopy guide

Google Forms response sheet formulas not copying

Use this when new Google Forms response rows appear but your helper formulas, formats, or calculated columns do not continue into those rows.

Quick answer

Common cause

Forms inserts new rows.

New response rows can appear without inheriting the formulas or formatting you expected.

Manual fix

Copy down from a model row.

Works for small sheets, but it is easy to forget after submissions arrive.

FormCopy path

Keep helper columns extended.

Use FormCopy when formula copying is part of the recurring response workflow.

Boundary

Test on copied data.

Confirm the model row and target columns before using it on a live response sheet.

Safe setup

  1. Copy the response sheet or use a test form.
  2. Identify the model row and helper columns.
  3. Submit one test response.
  4. Confirm formulas and formats appear in the new row.

Next steps