Build a checkbox-based task tracker in Google Sheets

Quick answer

Select your task-state cells and choose Insert > Checkbox. If the workflow uses explicit labels such as Yes and No, set custom checkbox values in Data > Data validation and make the summary count those exact values.

Set up four tasks with observable states

Use a private native Google Sheets spreadsheet in a desktop browser with edit permission. This guide uses the ordinary checkbox and validation controls, not a mobile setup workflow or a paid project-management feature. Keep a separate copy before changing validation in an existing tracker.

Enter A1:C5 with column B initially empty:

Task	Done	Owner
Count stock		Alex
Check labels		Blair
File receipts		Casey
Review totals		Alex

The four task rows are the denominator. A heading, a note or a spare checkbox below the task list is not another task. The intended first state is Count stock and File receipts complete, with Check labels and Review totals still open.

Insert and define the controls

1. Select B2:B5, leaving B1 out.
2. Choose Insert > Checkbox. Confirm that four controls appear beside the four tasks.
3. With B2:B5 selected, choose Data > Data validation.
4. For the rule’s Criteria, choose Checkbox and enable Use custom cell values.
5. Enter Yes as Checked and No as Unchecked, then save the rule. Google’s checkbox help labels the final action Save; if the current validation panel presents Done, finish the rule there.
6. Establish the intended state by checking B2 and B4 and leaving B3 and B5 unchecked. Inspect the underlying cell values as well as the visual marks.

Custom values matter. A checked cell in this rule means the text Yes, not an assumed Boolean TRUE. If old values are invalid after changing the rule, reset each practice checkbox to the required state and verify its underlying value rather than accepting a warning as completion.

Count the same states that the rule stores

Enter E1 = Completed, E2 = =COUNTIF(B2:B5,"Yes"), E3 = =COUNTIF(B2:B5,"No") and D3 = Still open. Enter D2 = Completed tasks so both summary numbers have labels. These formulas use English function names and comma argument separators; adapt the separator if your spreadsheet locale requires it.

The first result should be E2 = 2 and E3 = 2. Their sum is 4, matching the task count. This is a useful consistency check: if the sum is less than four, inspect blank or invalid states rather than assuming all unchecked cells have the custom No value.

In E4 enter =E2/4. The value should be 0.5, equivalent to 50% of the four tasks. The fixed denominator is deliberate for this bounded exercise; if you add tasks later, review both the count ranges and denominator instead of relying on an outdated percentage.

Test completion and reversal

Check B3. Completed should become 3, open should become 1 and E4 should become 0.75. Uncheck B2. The counts return to 2 and 2, but the completed task identities are now Check labels and File receipts. A total alone cannot prove the right tasks are complete, so inspect the rows as well.

For the final state, check B2 again. Leave B2:B4 checked and B5 unchecked: three of four tasks are complete. After online saving, reopen and verify the marks, the stored Yes/No values and the 3/1 summary.

Maintain and recover the tracker

Do not type Done into a Yes/No rule without also redesigning the criteria. If the count remains zero, check for Boolean values from an older rule or a mismatch between the custom value and formula criterion. COUNTIF is not case-sensitive, but it does not infer that Done means Yes.

Rehearse checkbox removal only in a disposable copy. Google’s documented Delete action removes selected checkboxes; do not assume it preserves the completion record you need. Keep the final tracker intact and restore the practice copy from known states if necessary.

For restricting who can edit summary formulas while leaving the checkboxes usable, see protect formula cells and leave inputs editable. A checkbox itself is not a permission control.

Official references

• Add & use checkboxes - Computer - Google Docs Editors Help
• COUNTIF: conditional counts

Documentation basis: first-party help snapshots captured 20 October 2026. Fixture arithmetic and stated changes were checked independently. No native Google Sheets session, Excel round trip, screenshot, sharing action or export was executed for this article.