How to Build a Kanban Board in Google Sheets (Step-by-Step)
Why Build a Kanban Board in Google Sheets?
Purpose-built kanban tools like Trello or Linear are faster to set up, but Google Sheets offers something they don't: your data stays inside Google Drive, where your team already works. There's no new tool to learn, no separate login, and the board is a spreadsheet — meaning you can slice, filter, and analyze your tasks with formulas that kanban apps can't match.
The trade-off is that Sheets requires manual setup and doesn't give you drag-and-drop card movement.
Basic Structure: Columns as Status Lanes
The simplest kanban board in Sheets uses one row per task and a status column that acts as your swim lanes. Here's the recommended column structure:
- A: Task — short description of the work item
- B: Status — dropdown: To Do / In Progress / Review / Done
- C: Assignee — team member name or email
- D: Due Date — date format for sorting
- E: Priority — High / Medium / Low
- F: Notes — free text for context
Step 1: Add Data Validation for Status
Select the entire Status column (B2:B500), then go to Data → Data validation. Choose "List of items" and enter: To Do, In Progress, Review, Done. This turns the column into a dropdown and prevents typos that break filtering.
Step 2: Apply Conditional Formatting for Visual Clarity
Select the full data range (A2:F500) and go to Format → Conditional formatting:
- Custom formula:
=$B2="In Progress"→ light blue background - Custom formula:
=$B2="Review"→ light yellow background - Custom formula:
=$B2="Done"→ light green background, strikethrough text - Custom formula:
=AND($D2<TODAY(),$B2<>"Done")→ red background (overdue tasks)
Step 3: Create Filter Views per Status Lane
Go to Data → Filter views → Create new filter view. Name it "In Progress" and set a filter on column B to show only "In Progress" rows. Repeat for each status. Team members can switch between views without affecting what others see.
Step 4: Add a Summary Dashboard
On a second sheet tab, use COUNTIF formulas to display task counts per status:
=COUNTIF(Tasks!B:B,"In Progress")Add a bar chart based on these counts for a quick visual summary of project health.
Step 5: Automate with Apps Script (Optional)
For teams that want email notifications when tasks change status, Google Apps Script can watch for edits. Go to Extensions → Apps Script and add an onEdit trigger that sends a Gmail notification when column B changes to "Review".
Limitations of the Sheets Approach
A Sheets kanban works well up to about 50-100 active tasks with a team of 5-8. Beyond that, you'll encounter:
- No drag-and-drop card movement — status changes require editing a cell
- No per-card comments or attachments natively
- Simultaneous editing can cause conflicts
- No mobile-friendly board view
When to Use a Dedicated Tool Instead
If your team needs real drag-and-drop, card-level discussions, or file attachments on tasks, move to a purpose-built tool. For teams already deep in Google Workspace, TaskGrid builds a visual kanban board directly on top of a Google Sheet, giving you drag-and-drop without moving your data out of Drive.