In this video, I'll show you step-by-step how to create a dynamic Kanban board in Google Sheets. Whether you're looking for a complete project management tool or simply a better overview of your tasks, this tutorial will guide you through every step.
What you'll learn:
How to define your own project phases
How the board automatically populates from your backlog
How to visualize priorities and deadlines
How to manage an unlimited number of projects and team members
How to set individual WIP (Work in Progress) limits for each phase
and much more :-)
Best of all: Google Sheets is free, and all you need is a Google account!
Timestamps:
00:00 Introduction
01:58 Project Backlog
05:50 Kanban Board
12:10 Conditional Formatting
16:40 WIP Limits
22:00 Completion
23:15 Usage
25:50 End
💡 Note: In this tutorial, I'll show you all the basic functions. If you'd like more advanced features like the filter function, check out my pre-made Kanban board template, which I offer on my website. With this template, you can easily filter by priority and assignee, making your project management even more efficient! https://www.cemiscode.com/kanban-board/
👉 Also, check out my website! In addition to this template, you'll find many other helpful tools there – some of them are even free! Get your template here: https://www.cemiscode.com