Home › Automations › Hide a row when a checkbox is ticked in Google Sheets
Trigger: Column updatedAction: Hide row

Hide a row when a checkbox is ticked in Google Sheets

Done items shouldn't clutter the view — but you don't want to delete them either. Tick the checkbox and the row hides itself, data intact.

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, the row is hidden from view while staying fully in the sheet — formulas, references, and history all keep working. Perfect for task lists, packing lists, and review queues where finished rows should get out of the way but remain on record.

How to set it up

  1. Install Sheet Automation from the Google Workspace Marketplace and open it from your sheet.
  2. Pick the “Hide row when checkbox is ticked” template.
  3. Set the checkbox column if it isn't column A.
  4. Save. Tick a checkbox — the row disappears from view immediately.

The ready-made template

Hide row when checkbox is ticked — Trigger: checkbox in column A is ticked → Action: hide the row. 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 “Hide row when checkbox is ticked”.
  4. Adjust the fields to match your data, then click Save.
  5. Trigger it once to confirm the automation runs.

FAQ

Is the row deleted?
No. It's only hidden — unhide it any time from the row menu, and formulas referencing it keep working.
Can I hide based on a status value instead of a checkbox?
Yes. Change the condition to match any value, e.g. status equals Done.
Can rows be unhidden automatically too?
Yes. Create a second rule with the Hide Row action in unhide mode when the box is unticked.

Related automations

Move a row when a checkbox is ticked Move a row when status changes to Done Format a row when a task is completed Send an email when a checkbox is ticked