What is Kanban in Google Sheets?
Kanban boards show work moving through stages like To do, Doing, and Done. In Google Sheets, you simulate the board with status columns, filter views per stage, or horizontal column layouts where each stage is a range. It is ideal for small teams already collaborating in a spreadsheet.
When to use it
Use a sheet Kanban when you want a visual pipeline without buying software: editorial queues, software tickets before you adopt Jira, or household projects with a shared Chromebook.
When to skip it
Skip sheet Kanban when you need true drag-and-drop cards with attachments and SLAs at scale. Very active boards become scroll-heavy without dedicated tools or add-ons.
How it works
-
1
Define stages as a dropdown Status column or as fixed column headers across the sheet.
-
2
Keep one card per row with Title, Owner, Due, and Priority fields for sorting within a stage.
-
3
Use filter views named by stage so each view looks like a lane, or lay out lanes side by side with QUERY.
-
4
Color by priority or age with conditional formatting so stale cards stand out.
-
5
Move cards by changing Status, not cutting rows, so formulas and ids stay intact.
-
6
Review WIP limits by counting rows in Doing and agreeing as a team to cap that number.
Examples in Google Sheets
Filter view lanes
Master table with Status dropdown; filter views Todo, Doing, Done hide other rows so standup scans fast.
Horizontal swimlanes
Columns B, E, H hold card blocks separated by blank columns; ARRAYFORMULA lists titles per stage from a Data tab.
Personal Kanban
Single user board with This week, Backlog, Waiting on; checkbox Done archives via filter on a hidden column.
Better Sheets resources
Common mistakes
-
Deleting rows when moving stages instead of updating Status, breaking links and history.
-
Too many lanes so cards stall in vague In progress states forever.
-
Giant merged cells for card art that break copy-paste and mobile editing.
-
No owner on cards, so blocked items sit unnoticed in Doing.
-
Building the board before agreeing definitions of Done and Doing with the team.
Frequently asked questions
- Can I drag cards between columns in Sheets?
- Native drag moves cell content, not card objects. Change Status or use an add-on for richer drag UX.
- Kanban vs filter views?
- Filter views simulate lanes on one table. Horizontal layouts look more board-like but are harder to maintain.
- How many cards per lane?
- Keep Doing small. If a lane has dozens of rows, split work or archive done items weekly.
- Does Kanban need Apps Script?
- No for basic boards. Script helps for auto-archiving or notifying when cards sit too long in one stage.
- Can I attach files to cards?
- Use a Drive link column per row. Sheets is not a file cabinet like dedicated Kanban apps.
- WIP limits in Sheets?
- COUNTIF on Status="Doing" in a visible cell; team agrees not to pull new work when over the limit.
- Kanban for scrum sprints?
- Add Sprint id column and filter views per sprint on the same backlog table.
- How does Kanban relate to workflows?
- Kanban is a visual workflow style. Under the hood you still need clear statuses and owners documented in this glossary.
Related Tutorials
Watch how Kanban in Sheets works
Automated Project Management in Google Sheets
Create a Trello Board with Transpose Formula in Google Sheets
Organize Anything! - Build a Kanban Board / Trello Board
Related blog posts
Guides that explain Kanban in Sheets in more depth.
Organize Your Data! - Build a Kanban Board / Trello Board
Effortlessly organize tasks using Google Sheets! Learn impressive formulas, create Kanban/Trello boards, and optimize your life and workflow.
Read post →How to Use Google Sheets for Advanced Project Management
Master Google Sheets for project management with these advanced tips. Check our free tutorials, tools, and templates for data management, task flow, and much more.
Read post →Automated Project Management in Google Sheets
When you have multiple people working on multiple tasks, and you want everyone to be on the page, what do you do? You can use a Google Sheet. But managing projects can be an intimidating task in Google Sheets. It's a lot of data entry, right? Especially when you have multiple people working on different tasks with different statuses across different projects. Data entry for multiple projects, with different people, tasks, and statuses – it gets messy fast! I'm no stranger to these issues...
Read post →Related terms
Google Sheets workflows
A workflow is the path work takes through your sheet: intake, review, approval, done. Good workflows use consistent columns, statuses everyone understands, and just enough automation to move tasks forward without hiding steps from the team.
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 →dashboards
A dashboard is a single view that answers "how are we doing?" without hunting across tabs. In Google Sheets, it is usually a summary tab with big numbers, charts, and conditional formatting fed by QUERY, pivot tables, or IMPORTRANGE from raw data you keep elsewhere.
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 →Done reading about Kanban in 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.