Checkboxes in Google Sheets: a checklist in under a minute

Tracking done/not-done doesn't need a separate app. Google Sheets has a built-in feature that turns any range of cells into interactive checkboxes — and because they're still just ordinary spreadsheet cells, you can attach conditional formatting and formulas to them that automatically tally how much is done.

A typical scenario

You keep a task list for a small project in a spreadsheet and need to quickly see what's done and what isn't, without setting up a whole separate task app for it. Without checkboxes, you type “yes” or “done” by hand into a column next to each task, which is slow both to type and to evaluate afterward, since the text can be written inconsistently and is hard to count reliably. With checkboxes, a click is enough — the box flips to checked, a formula automatically counts how many tasks are done, and conditional formatting can gray out finished rows right away, so you can tell them apart from unfinished ones at a glance.

How to do it

1. Select the range of cells where you want checkboxes — typically one column next to your task list.
2. From the top menu, go to Insert → Checkbox.
3. An interactive checkbox appears in each selected cell — click it to toggle between checked and unchecked, while behind the scenes the cell holds a value of TRUE (checked) or FALSE (unchecked).
4. To see how many tasks are done, use the formula =COUNTIF(A:A, TRUE) in a separate cell (replacing A:A with your actual checkbox column) — it counts how many boxes are currently checked.
5. You can set up conditional formatting (Format → Conditional formatting) so that a row with TRUE in the checkbox column automatically grays out or strikes through the task text — visually separating finished items from the rest without having to manually delete or move them.

The best tools

• Built-in checkboxes in Google Sheets — free, works like an ordinary cell, so it combines easily with formulas and formatting.
• A similar feature in Excel (via the Developer tab or data validation) — the same idea for Microsoft 365 users, a bit more involved to set up.
• A dedicated task app (Todoist, Trello, and similar) — a better fit once the checklist grows into a project with deadlines, assigned people, and dependencies between tasks.

What you get out of it

• Time: an estimated 5 minutes a week saved compared to typing and recalculating a done/not-done status by hand in text.
• Clarity: you see the ratio of done to not-done at a glance, especially combined with conditional formatting.
• Fewer errors: a checkbox only has two states, eliminating the risk of typos or inconsistent entries (“done” vs. “Done” vs. “yes”).
• Easy status sharing: colleagues see the same checklist in real time, without having to ask what's finished.

Pro tip

You can assign custom values to checkboxes instead of the default TRUE/FALSE — in the insert dialog, choose Use custom cell values and set something like “Done” and “Pending.” Formulas then need to reference these custom labels instead of TRUE/FALSE.