Task Tracker Google Sheets: Build a Free Project Tracker in 2026

Google Sheets is already open in most teams’ browsers. It handles budgets, reports, and client data, so it makes sense that people also reach for it when they need a task tracker. A well-built task tracker in Google Sheets can absolutely work for individuals and small teams, and it costs nothing extra if you are already on Google Workspace.

This guide walks you through building a practical Google Sheets task tracker from scratch, covers templates, shows you how to add kanban-style views and checklists, and explains the point at which a dedicated tool becomes a better investment.

How to Create a Task Tracker in Google Sheets

Building a task tracker in Google Sheets takes about 15 minutes if you start from a blank spreadsheet. Here is the core setup that works for both personal to-do lists and team projects.

Step 1: Set Up Your Task List Columns

Open a new Google Sheet and create these column headers in row 1:

• Task: The name of the task or deliverable
• Owner: Who is responsible (name or email)
• Status: Current state (Not Started, In Progress, Done, Blocked)
• Priority: High, Medium, or Low
• Due Date: Target completion date
• Notes: Any context, links, or dependencies

Freeze row 1 so headers stay visible as you scroll down. Go to View > Freeze > 1 row.

Step 2: Add a Status Dropdown with Data Validation

Free-text status columns get messy fast. Use data validation to enforce consistent values:

1. Select the entire Status column (click the column letter)
2. Go to Data > Data validation
3. Under Criteria, choose Dropdown (from a list)
4. Enter your values: Not Started, In Progress, Done, Blocked
5. Click Save

Now everyone on the team picks from the same options instead of typing “in progress”, “WIP”, “ongoing”, or any other variation.

Step 3: Add Google Sheets Checkboxes for Quick Wins

For simple to-do lists, checkboxes are faster than dropdowns. Select the cells in your Status column (or add a new “Done” column), then go to Insert > Checkbox. Each cell toggles between TRUE and FALSE when clicked.

You can use this for a Google Sheets to-do list where you just need a quick visual of what is complete. For team task trackers, the dropdown approach from Step 2 gives you more nuance.

Step 4: Apply Conditional Formatting for Visual Status

Color-coding turns a flat list into a scannable tracker:

1. Select your Status column
2. Go to Format > Conditional formatting
3. Add a rule for each status value:
   • “Done” → green fill (#b7e1cd)
   • “In Progress” → yellow fill (#fce8b2)
   • “Blocked” → red fill (#f4c7c3)
   • “Not Started” → no fill or light gray

Repeat this for the Priority column: red for High, orange for Medium, gray for Low.

Google Sheets Checklist for Recurring Tasks

For teams with recurring workflows (weekly reports, monthly reviews, onboarding checklists), a dedicated checklist tab works better than mixing recurring and one-off tasks in the same view.

Create a second sheet tab called “Checklist” and set it up as a reusable template:

• Column A: Checkbox (Insert > Checkbox)
• Column B: Task description
• Column C: Notes or link to documentation

Each time the cycle repeats, uncheck all boxes and start fresh. This is a simple but effective Google Sheets checklist pattern that does not require any add-ons.

For teams that need checkboxes to reset automatically or that want subtask nesting, this approach hits its limits quickly. That is a good signal to consider a tool built around task hierarchies.

Google Sheets Kanban Board: A Visual Task View

A kanban board arranges tasks into columns by status, giving you a visual flow rather than a long list. You can approximate this in Google Sheets using a filtered view approach:

Option 1: Filter Views by Status

1. Select your task table
2. Go to Data > Filter views > Create new filter view
3. Filter the Status column to show only “In Progress” tasks
4. Name this view “In Progress Board”

Create separate filter views for each status. Team members can switch between views without affecting what others see. This is not a true kanban board, but it gives each person a focused view of tasks in a specific stage.

Option 2: Manual Kanban Layout

Create separate columns for each stage: Not Started | In Progress | Review | Done. Move task cards (rows of data) between columns manually. This works for small teams with fewer than 20 active tasks, but it breaks down when tasks multiply because you cannot sort, filter, or assign owners across a horizontal layout.

For a real Google Sheets kanban board experience, most teams eventually move to a tool that renders tasks as cards. TasksBoard connects directly to Google Tasks and displays them as a proper kanban board inside Google Workspace, with no migration required.

Try TasksBoard

TasksBoard gives your Google Tasks a full kanban board, list view, and team workspace, all synced with Google Calendar and accessible from any browser.

Get Started →

Google Sheets Project Management: What Works and What Does Not

Google Sheets project management covers a surprising range of tasks, but it has real limits. Here is an honest assessment:

What Google Sheets Does Well

• Flexibility: You can shape the tracker exactly as your team works. No predefined fields or required formats.
• Formulas: COUNTIF and SUMIF let you build summary dashboards that show how many tasks are complete, overdue, or assigned to each person.
• Sharing: Anyone with a Google account can view or edit a shared sheet. No extra seats or software to install.
• Import and export: Data from other tools (CSV exports, API pulls) drops in easily. This is especially useful for weekly reports.

Where Google Sheets Falls Short

• No notifications: Sheets does not ping an owner when their task is due or when someone comments on a specific task row.
• No task dependencies: You cannot set “Task B starts only when Task A is done” natively. Workarounds with formulas exist but are brittle.
• No calendar sync: Due dates in a spreadsheet stay in the spreadsheet. They do not appear in Google Calendar automatically.
• Collaboration friction: When two people edit the same row at the same time, conflicts appear. Task management tools handle concurrent edits with purpose-built locking.

For individuals tracking personal projects or small teams running straightforward workflows, Google Sheets project management works fine. When your team grows past five people or your projects involve dependencies and recurring tasks, you will spend more time maintaining the spreadsheet than doing the actual work.

Free Task Tracker Google Sheets Templates

Rather than building from scratch, you can use a ready-made template. Google Sheets has several in its template gallery:

1. Open Google Sheets at sheets.new
2. Click File > New > From template gallery
3. Search for “project tracker” or “to-do list”

The built-in templates give you a solid starting point. You can also search Google for “task tracker Google Sheets template free” to find community templates, many of which include color-coded priority columns, progress bars, and summary dashboards.

When downloading external templates, check that the template does not use array formulas you cannot edit, does not include macros that require script permissions, and is not locked with protected ranges.

For related productivity tips in spreadsheets, see our guide to Google Sheets tips and tricks.

When to Move Beyond Google Sheets

A Google Sheets task tracker is a great starting point, but most teams outgrow it within a few months of using it seriously. Signs that you need a dedicated tool:

• Tasks are falling through the cracks because nobody sees the sheet regularly
• You are spending time maintaining the spreadsheet instead of doing the work
• You need task assignments with notification emails
• You want recurring tasks that reset automatically
• Your team already uses Google Tasks and you want a better interface for them

TasksBoard is built for exactly this transition. It connects to Google Tasks natively, which means all your existing tasks migrate without any import. You get a full-screen kanban board, list view, and a team workspace where multiple people can see and update tasks in real time. If your team is inside Google Workspace, there is no faster way to get a proper task management setup.

For a deeper look at how TasksBoard compares to the default Google Tasks interface, read our TasksBoard review. And if your team needs to share tasks with colleagues who are not yet using a task tool, our guide on how to share Google Tasks covers the options.

Upgrade from Spreadsheets to TasksBoard

Stop maintaining your task tracker manually. TasksBoard connects to Google Tasks and gives you a real kanban board, team workspace, and Google Calendar sync in minutes.

Try Free →

FAQ

Conclusion

A task tracker in Google Sheets is one of the most practical tools you can build in an afternoon. Start with a simple table, add status dropdowns and conditional formatting, and you have a working system that your whole team can use immediately with no extra cost.

As your projects grow, the patterns in this guide scale reasonably well. Use filter views for a basic kanban board, add checkboxes for recurring checklists, and lean on formulas for project dashboards. When you hit the limits of what a spreadsheet can do, the natural next step for Google Workspace teams is TasksBoard, which turns Google Tasks into a full-featured project board without requiring any migration or new accounts.

For more ways to get more done inside Google Workspace, see our guides on Google Tasks for teams and Google Workspace project management.