Tasks in a spreadsheet for a family or a small team
A small team or a family can run tasks in a shared spreadsheet perfectly well: one row per task, a status column that acts as a mini kanban (To do / In progress / Done), an assignee and a due date, all in a Google Sheet everyone can open. It beats a heavy project tool when your group is under about eight people and your task list is under a hundred.
Small groups do not need project management software
The moment a family or a five-person team needs to track who is doing what, someone suggests a proper tool: Trello, Asana, Jira. For a group that size it is usually overkill. You end up maintaining the board more than doing the work, half the group never opens the app, and the real coordination still happens in a chat. A shared spreadsheet removes all of that friction — everyone already has access, nobody needs to learn a new interface, and the file can be as simple or as rich as you want.
One row per task, four columns that matter
The whole system runs on a short table:
| Column | Purpose |
|---|---|
| Task | What needs doing, one clear sentence |
| Status | To do / In progress / Done — this is your kanban |
| Assignee | Who owns it, one name, no hand-waving |
| Due | The date it must be finished by |
Add a priority column if you genuinely juggle urgent and important work, but resist adding more. Every extra column is a reason for someone to stop filling the sheet in.
The kanban is a filter, not a board
In a real kanban tool you drag cards between columns. In a spreadsheet you keep one table and filter by status — the effect is the same and it stays sortable. When someone opens the file they filter to "In progress" to see what the team is carrying right now, and "To do" to pick up the next thing. A status dropdown via data validation keeps the entries clean so the filter actually works.
Shared access is the real feature
Google Sheets gives you the part that matters: everyone sees the same live list, edits show up instantly, and there is a full revision history if a task mysteriously vanishes. Set the file so anyone with the link can edit, drop it in the family chat or the team channel, and pin it. No seats, no invitations to chase, no "which board was it again".
Where it stops working
This approach has a ceiling, and it is worth knowing. Past roughly eight people or a hundred active tasks, the single table gets noisy and you start wanting real assignment workflows, dependencies and notifications. Multi-project portfolios, time tracking, or client-facing reporting are also beyond what a sheet does gracefully. Up to that point though, a spreadsheet wins on simplicity — and when you outgrow it, you will have a clear list of what you needed, which makes choosing the real tool much easier.
Start from the template
The task tracker template here already has the four columns, a status dropdown, priority, due dates and a dashboard counting what is open, in progress and done. Copy it into your Drive, share the link, and your next team sync can be about the work instead of about the tool.