How do you build checklists in Google Sheets?
Checklists in Google Sheets use checkbox cells, done columns, or status dropdowns to track tasks row by row. Insert checkboxes from the Insert menu, pair them with COUNTIF percent complete formulas, and use conditional formatting to highlight overdue items still unchecked.
When to use it
Use checklists for onboarding steps, launch QA, audit prep, weekly reviews, and shared chores where multiple people need one visible list without buying another task app.
When to skip it
Move to a ticket system when tasks need comments, attachments, SLAs, or private threads per item. Sheets checklists excel at simple visible completion, not complex dependency graphs.
How it works
-
1
List tasks in column A; select column B and Insert > Checkbox to add TRUE FALSE toggles.
-
2
Add formula =COUNTIF(B:B,TRUE)/COUNTA(A:A) for percent complete banner at top of tab.
-
3
Optional status column with Not started, In progress, Done for workflows that are not binary.
-
4
{:"Conditional formatting"=>"strikethrough or gray row when checkbox TRUE; red when due date passed and FALSE."}
-
5
Sort with filter view that hides completed rows so active checklist stays short during busy weeks.
-
6
Protect task names column so editors only tick boxes, not rename steps mid-audit.
Examples in Google Sheets
Product launch QA checklist
Twenty rows with owner column and checkbox; dashboard QUERY counts open items per owner for standup.
New hire first-week list
HR template mixes checkbox tasks and link cells to handbook; percent complete visible to manager view.
Client onboarding milestones
Status dropdown per milestone with due date; conditional formatting flags items stuck In progress seven days.
Better Sheets resources
Common mistakes
-
Checkbox column with text like "yes" mixed in, breaking COUNTIF percent formulas.
-
Deleting completed rows to clean up, losing audit trail of who finished what and when.
-
No due date column, so everything looks equally urgent and nothing gets prioritized.
-
Letting anyone add joke rows in a regulated checklist without protect ranges on structure columns.
-
Checklist on same tab as fragile formulas with no separation between input tasks and calc area.
Frequently asked questions
- Checkbox vs CHAR symbol?
- Native checkbox is sortable and works with COUNTIF. Unicode checkmarks are fine for display-only lists.
- Assign checklist per person?
- Add Owner column and filter views per email, or duplicate personal copy from master template.
- Timestamp when checked?
- onEdit can write NOW() in adjacent column when checkbox turns TRUE if you need completion audit.
- Checklist template copy?
- Ship master with checkboxes cleared and instructions on README so buyers start from empty TRUE FALSE.
- Mobile checklist editing?
- Checkboxes work in mobile Sheets app; keep rows short and font large for field teams.
- Link checklist to calendar?
- Due dates can feed conditional formatting; full calendar sync usually needs script or external tool.
- Nested subtasks?
- Indent task names or use outline column numbering; subtask percent can roll up with SUMPRODUCT helpers.
- Checklist for viewers?
- Viewers cannot tick boxes. Share commenter or editor access on checklist tab only if needed.
Related Tutorials
Watch how checklists in Google Sheets works
Uncheck Every Checkbox in Google Sheets
Ultimate Checklist in Google Sheets
One Million Checkboxes
Spreadsheet Automation 101 Lesson 2: If ( ){ } and Checkboxes
Automatically Uncheck A Daily Checklist
Magical Things You Can do with Checkboxes in Google Sheets
Related blog posts
Guides that explain checklists in Google Sheets in more depth.
The Simplest Bestest Checklist in Google Sheets
Build the ultimately, best, and simplest checklist. Designed well, and FUN to fill out!
Read post →How to Use Checkboxes for Approvals, and Change the Checkbox Text
Learn how to customize checkboxes for various uses, create rating systems, add dropdown menus, and more. Explore the creative possibilities of Google Sheets!
Read post →How To Hide Data with Checkboxes in Google Sheets
Google Sheets, Google Sheets Tutorials | This tutorial is meant to show you not just what magical things you can do with checkboxes, but also to show you my process on how when you become a member of Better Sheets.
Read post →Related terms
onboarding users to a spreadsheet
Onboarding teaches new editors where to type, what not to touch, and how work flows through the file. A strong onboarding sheet combines a README tab, protected formula areas, sample rows, and a short checklist so first-time users succeed without breaking dashboards or overwriting settings.
Read guide →trackers
A tracker is a living list you update over time: tasks, leads, inventory, habits, or bugs. Good trackers use one row per item, clear statuses, and columns that sort and filter without cleanup scripts. They often feed a dashboard tab when the team outgrows scanning raw rows.
Read guide →conditional formatting
Conditional formatting changes how cells look when they meet rules you define, such as values above a target or dates in the past. It helps scanners spot problems fast without writing values into extra helper columns. Rules can be simple comparisons or custom formulas that reference other sheets.
Read guide →dropdowns / data validation
Data validation restricts what people can type in a cell. A dropdown is the friendly face of that feature: pick from a list instead of free text. It keeps statuses, categories, and owners consistent so filters, pivot tables, and scripts do not break on typos.
Read guide →planners
A planner layout helps you schedule work across days, weeks, or project phases inside a spreadsheet. Unlike a one-off todo list, planners emphasize dates, time blocks, and recurring rhythms you copy forward. They work well for personal systems and small teams who already live in Google Workspace.
Read guide →Done reading about checklists in Google Sheets?
Membership unlocks 600+ tutorials, unlimited generators, and every template. Practical lessons. Zero fluff.
Need this once
Jump to a free tool or a single tutorial for this topic.
Learning Sheets for real
Unlock the full library, generators, and templates with membership.