Move a row to another sheet when status changes to Done

What it does

This automation watches the status column. When a cell in it changes to Done, the entire row is cut from the active sheet and appended to the sheet you choose — preserving every value. Ideal for task trackers, order pipelines, and ticket queues where finished items should disappear from the working view but stay on record.

How to set it up

1. Install Sheet Automation from the Google Workspace Marketplace and open it from your tracker sheet.
2. Pick the “Move row when status changes” template.
3. Set the status column, the value to match (e.g. Done), and the destination sheet.
4. Save. Change a status to Done — the row jumps to the archive instantly.

The ready-made template

Move row when status changes to Done — Trigger: column C is updated → Condition: C equals Done → Action: move the row to Archive. Edit it live below:

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 status changes to Done”.
4. Adjust the fields to match your data, then click Save.
5. Trigger it once to confirm the automation runs.

Related automations