Home › Automations › Move a row to another sheet when a checkbox is ticked in Google Sheets
Trigger: Checkbox tickedAction: Move row

Move a row to another sheet when a checkbox is ticked

Keep your active sheet clean. The moment a checkbox is ticked, Sheet Automation moves that row to another sheet automatically.

Add to Google Sheets — free See the template

Installs in 30 seconds · No credit card · Works inside Google Sheets

★★★★★ 4.9/5 · 500+ reviews · 300,000+ installs

What it does

This automation watches a checkbox column. When a box is ticked (TRUE), it moves the whole row to another sheet — perfect for archiving completed tasks, processed orders, or done items. Your main sheet stays focused on what’s still open.

How to set it up

  1. Install Sheet Automation from the Google Workspace Marketplace and open it from your sheet.
  2. Add a checkbox column (Insert → Checkbox) and a destination sheet, e.g. Sheet2.
  3. Pick the “Move row when a checkbox is ticked” template, set the checkbox column and the destination sheet.
  4. Save, then tick a checkbox to test — the row moves to the other sheet.

The ready-made template

Move row when a checkbox is ticked — trigger: a checkbox column is updated → condition: the box is TRUE → action: move the row to another sheet. Edit it live below:

Loading preview…

How to use this template

The builder above is a live preview of this automation. To run it in your own spreadsheet:

  1. Click Add to Google Sheets to install Sheet Automation (free).
  2. Open it from your sheet: Extensions → Sheet Automation → Open.
  3. Open the Templates tab and choose “Move row when a checkbox is ticked”.
  4. Set the checkbox column and the destination sheet to match your data, then click Save.
  5. Tick a checkbox to confirm the row moves.

FAQ

Is it free?
Yes — this automation works on the free plan. Paid plans add more monthly runs and advanced actions.
Where does the row go?
To the destination sheet you choose in the template (e.g. Sheet2). The row is removed from the source sheet.
Will unticking move it back?
No. The rule runs when the box is ticked (TRUE); it doesn’t move rows back when unticked.
Can I move rows on a different condition?
Yes. Swap the condition — e.g. status equals “Done” — instead of a checkbox.
Do I need Zapier or Make?
No. Sheet Automation runs inside Google Sheets, so there’s no third-party connector to pay for or maintain.

Related automations

Send an email when a checkbox is ticked Send an email when a cell is updated Format a row when a task is completed Post to Google Chat when a row is added