At a glance
A task spreadsheet needs consistent columns for the work, owner, status and deadline. Keep it simple, update it regularly and use filtering to surface what needs attention next.
A useful task sheet needs one row per action, a clear owner, a due date, and a status you update regularly. Start with a small table and a weekly review before adding formulas or dashboards.
1. Create the task table
Open a blank spreadsheet and name it for the team or project. In the first row, add these columns: Task, Project, Owner, Due date, Priority, Status, and Notes. Write tasks as actions: “Send the revised proposal” is easier to act on than “Proposal.”
Add three real tasks before formatting. This reveals whether your columns capture the information you actually use.
| Task | Owner | Priority | Status |
|---|---|---|---|
| Confirm the project brief | Alex | High | In progress |
| Prepare the first draft | Sam | Medium | Not started |
| Send the weekly update | Alex | Medium | Done |
2. Add consistent status choices
Select the cells under Status. Open Data → Data validation → Add rule, choose Dropdown, and add your status values. Three or four choices are enough: Not started, In progress, Waiting, and Done. Apply the rule to the rows you expect to use.
Do the same for Priority if consistent labels would help. See Google’s dropdown instructions for current desktop options. Avoid assigning “High” to every task; agree on what each priority means.
3. Filter the complete table
Select the table, including all its columns, and use Data → Create a filter. Filter Status to hide finished work, or sort the full range by due date. Sorting one column alone can separate a task from its owner or deadline.
On a shared sheet, a filter view lets you inspect your own selection without changing everyone’s view. Follow Google’s filter and filter-view guidance. Check that new rows fall within the range you are filtering.
4. Choose one completion signal
The Done status may be enough. If you prefer a checkbox, add a completion column, select its cells, and choose Insert → Checkbox. Google documents the available settings in its checkbox guide.
If you keep both a status and a checkbox, define how they stay consistent. Otherwise, a checked task may still appear as “In progress.”
5. Share and review the tracker
Give access only to the people who need the sheet and choose whether each person can view or edit it. Avoid putting private client details in a tracker shared broadly with a team.
During a weekly review, update the active tasks, inspect overdue work, and check waiting items. Move completed work to an archive only after deciding whether you still need it in your filters or reports.
When to move beyond a spreadsheet
Keep the sheet while it remains easy to maintain. Consider a dedicated planner when you spend more time reconciling task lists and calendars than doing the work. Test one project in ProjectBook’s planner before deciding whether a different tool improves your routine.
From ideas to a clearer week