A Google Sheets task tracker is a shared spreadsheet where each row is a task, with columns for the owner, due date, priority and status, plus dropdowns and color rules that keep it tidy. You can build a useful one in under an hour with features already in Google Sheets, and for a small team with simple work it may be all you need.
Spreadsheets are where many teams start tracking work, and for good reason: everyone knows how to use them and there's nothing new to buy. The difference between a tracker that helps and one that goes stale in a month usually comes down to a few setup choices. This guide walks through building one step by step, using features described in Google's own help pages, then covers the honest limits and the signs it is time to move on.
Step 1: Plan your columns
Keep it short. Every extra column is one more thing people have to fill in, and the more you ask for, the less gets updated.
| Column | What goes in it | Tip |
|---|---|---|
| Task | A short action, starting with a verb | "Send revised quote to the Hartley job," not "Hartley" |
| Owner | One person's name | Never two names in one cell |
| Due date | The date it's due | Format the column as a date |
| Priority | High, Medium or Low | Use a dropdown |
| Status | To do, In progress, Waiting, Done | Use a dropdown |
| Notes | Blockers or a link to a file | Keep it brief |
| Done date | When it was finished | Useful for looking back |
Put the headers in row 1. Then, from the menu, choose View and then Freeze to keep the header row in place as the list grows.
Step 2: Add dropdowns for status, priority and owner
Dropdowns stop the same status being typed five different ways. According to Google's help center, you can select the cells and choose Insert and then Dropdown, or use Data and then Data validation and add a rule.
- Select the Status column below the header.
- Choose Insert, then Dropdown.
- Enter your options: To do, In progress, Waiting, Done.
- Repeat for Priority, and for Owner with your team's names.
Google's help page explains that you can also build a dropdown from a range of cells, which is handy for an Owner list kept on a separate tab. Under Advanced options, you can choose what happens with invalid data: reject the input, or show a warning. For a team tracker, rejecting invalid input keeps the data clean. You can also add a checkbox column with Insert and then Checkbox if you prefer ticking to choosing "Done."
Step 3: Use conditional formatting to make problems visible
Color is what turns a list into a tracker you can read at a glance. Select your data range, then choose Format and then Conditional formatting.
- Highlight finished tasks. Use "Custom formula is" with a formula that checks the Status column. Google's help page shows that a formula like =$E2="Done" formats the whole row based on one cell, when the range covers all your columns. Choose a pale gray.
- Flag overdue tasks. Add another custom formula rule, for example =AND($C2<TODAY(), $E2<>"Done"), where column C holds the due date and column E the status. Choose a light red. TODAY returns the current date and AND checks that both conditions are true.
- Mark high priority. A simple rule on the Priority column, such as text is exactly "High," with bold text.
Adjust the column letters and starting row to match your sheet.
Step 4: Give each person a view with filter views
A filter changes what everyone sees. A filter view changes only what you see. Google's help page describes filter views as applying only to your view of the spreadsheet, so they are ideal for a shared tracker.
- Choose Data, then Create filter view.
- Filter the Owner column to one person, and the Status column to hide "Done."
- Rename the view, for example "Maria's open tasks."
- Copy the page address while the view is applied and send it to that person.
Each person now opens a link that shows only their open work, while the full tracker stays intact for the manager. Google notes that someone with view-only access can create a temporary filter view that won't be saved.
Step 5: Share it with the right access
Use the Share button and add people by email. Google offers Viewer, Commenter and Editor roles. Team members who update tasks need Editor access; people who only need to look can be Viewers. Avoid setting general access to "Anyone with the link" for a tracker with client or staff details.
To stop accidents, you can protect key ranges, such as the header row or a tab of settings, by choosing Data and then Protect sheets and ranges. Google's help page explains you can restrict who can edit a range or just show a warning when someone tries.
Step 6: Agree on the habits
The sheet is the easy part. A tracker stays useful only if the team agrees how to use it.
- Add new tasks to the sheet not to chat
- Update status the same day it changes
- One owner per row
- Mark finished rows Done instead of deleting them
- Manager reviews overdue rows every week
The honest limits of a spreadsheet tracker
A Google Sheets tracker is a good tool with real limits. Knowing them early saves frustration later.
| Limit | What it means in practice |
|---|---|
| Nobody gets chased | The sheet won't nudge an owner when a row goes overdue unless you build something extra |
| Updates depend on memory | Status is only as current as the last person who remembered to change it |
| History is partial | Google notes that cell edit history needs edit access and doesn't show added or deleted rows or format changes |
| No proof step | There's nowhere natural for a photo of the finished job and a manager's approval |
| Everyone with edit access can change anything | Protected ranges help, but roles like "see only my department" aren't built in |
| Phones are awkward | Editing a wide spreadsheet on a small screen in a van is slow |
None of this makes spreadsheets bad. It means they work best when the team is small, the work is simple and someone keeps the sheet tidy. For a fuller comparison, see project tracking spreadsheets vs software.
When to move on
These signs suggest the tracker has done its job and the team has outgrown it:
- You spend time each week chasing people to update their rows.
- The sheet and the team chat tell different stories.
- Rows are marked Done but the work comes back.
- Several people edit at once and things get overwritten or sorted by mistake.
- Field staff stop updating because it is painful on a phone.
- You need managers to see only their own team's work.
At that point a shared task tool usually saves more time than it costs. Our buyer's checklist for task management software can help you choose. If your team also plans in Google's other apps, see how Google's planning tools fit together; for Google's own to-do app, see what Google Tasks is.
Where TaskFia fits
Moving on from a spreadsheet doesn't have to mean giving one up. On Basic plans and above, TaskFia syncs tasks, diaries and verifications to a Google Sheet that you own, so you keep a familiar record in your own account while the day-to-day work happens in an app with owners, reminders, a phone app and a proof-and-approval step. We explain the thinking in why your task data belongs in Google Sheets. Staff don't need Google accounts; only the admin connects Google.
Related guides. For shared daily lists, a to-do list app made for teams keeps an owner and a due date on every item. Learn the main types of to-do list and when each one works. Choosing for a mobile team? Read how to pick a task management app for iPhone, Android and the web. See how task management software built around proof of work keeps every task on the record.
Frequently asked questions
Can Google Sheets be used as a task tracker?
Yes. With columns for task, owner, due date, priority and status, plus dropdowns, conditional formatting and filter views, Google Sheets makes a workable tracker for a small team.
How do I add a status dropdown in Google Sheets?
Select the cells, choose Insert and then Dropdown, and enter your options. You can also use Data and then Data validation to add a dropdown rule.
How do I highlight overdue tasks in Google Sheets?
Use Format and then Conditional formatting with a custom formula that checks whether the due date is before TODAY() and the status isn't Done, then choose a highlight color.
Can each person see only their own tasks?
Each person can use a filter view that shows only their rows, and you can share a link to that view. Everyone with access can still open the full sheet, so it isn't a true permission.
When should a team stop using a spreadsheet tracker?
When chasing updates, overwritten rows or missing proof cost more time than the sheet saves, or when managers need to see only their own team's work.
The bottom line
A Google Sheets task tracker is a smart, low-cost start: keep the columns few, use dropdowns and color rules, give each person a filter view and agree on the update habits. When the team spends more time maintaining the sheet than doing the work, move the work to a task tool and keep the sheet as your record.
TaskFia is not affiliated with Google. Google Sheets, Google Drive and Google Tasks are trademarks of Google LLC.
Sources
- Google Docs Editors Help: Create an in-cell dropdown list
- Google Docs Editors Help: Add & use checkboxes
- Google Docs Editors Help: Use conditional formatting rules in Google Sheets
- Google Docs Editors Help: TODAY function
- Google Docs Editors Help: AND function
- Google Docs Editors Help: Sort & filter your data
- Google Docs Editors Help: Freeze, group, hide, or merge rows & columns
- Google Docs Editors Help: Share files from Google Drive
- Google Docs Editors Help: Protect, hide, and edit sheets
- Google Docs Editors Help: Find what's changed in a file