Navigation Title Kanban Template v1.

Setup Content This workbook is intended to help organize, track, a

Projects & Tasks The first tab allows for the setup of groups, projects
board.
Kanban The second tab is where data is entered.
Dashboard The third sheet is the Kanban board, where tasks c
The final tab (Dashboard) contains graphs providin

Customization difficulty (1-3) 3

Explanation of sheets
Setup: This sheet allows the user to enter the status drop-
to select the number of boards to be displayed on t
Projects & Tasks: This sheet is used to record and update all current
menus based on the Setup sheet data for convenie
Kanban: This is the Kanban board where tasks can be visua
are medium priority, and tasks with red dots are hig
filters to see only those tasks associated with certa

Filter Status: Throught this sheet you can filter Kanban according

Kanban Dashboard: This sheet contains graphs to summarize the proje

How to customize "Setup"

1) The "Heading/Status" options table is limited to 6 to

2) In order to add new Kanban boards, projects, or tea

"Projects & Tasks"

1) Enter tasks into the table and assign them to projec
about that task can be updated any time by changi
of data for that task by left-clicking and dragging. T

"Kanban"
1) Any time data is entered/updated on the Projects &
the Kanban tab in order for the new data to be refle
2) You can change Kanban status headings using dro

"Dashboard"
1) See instructions for "Kanban" sheet to see how to a
"Refresh Workbook" button has been clicked on the
Tasks.
All content is Copyright material of Simple Sheets L
http://www.simplesheets.co
© 2020 Simple Sheets LLC
All rights reserved.  The contents of this publication
No part of this publication may be modified, manipu
Kanban Template v1.2

This workbook is intended to help organize, track, and visualize your workflow.
The first tab allows for the setup of groups, projects, team members, and the number of columns in the Kanban
board.
The second tab is where data is entered.
The third sheet is the Kanban board, where tasks can be visualized.
The final tab (Dashboard) contains graphs providing summaries of the data.

This sheet allows the user to enter the status drop-down menu options, Kanban boards, projects and employees and
to select the number of boards to be displayed on the Kanban sheet.
This sheet is used to record and update all current tasks, along with their relevant parameters using drop-down
menus based on the Setup sheet data for convenience.
This is the Kanban board where tasks can be visualized. Tasks with green dots are low priority, tasks with yellow dots
are medium priority, and tasks with red dots are high priority. This sheet also allows the user to quickly apply various
filters to see only those tasks associated with certain teams, employees, etc.

Throught this sheet you can filter Kanban according to desired status using dynamic slicers

This sheet contains graphs to summarize the project & task data visually and is fully automated.

"Setup"
The "Heading/Status" options table is limited to 6 total entries, but the other tables don't have an entry limit.

In order to add new Kanban boards, projects, or team members, type in the next available cell in the applicable table.

"Projects & Tasks"

Enter tasks into the table and assign them to projects, team members, etc. Once a task is entered, the information
about that task can be updated any time by changing the information in each field. To remove a task, select the row
of data for that task by left-clicking and dragging. Then press the "delete" button on your keyboard.

"Kanban"
Any time data is entered/updated on the Projects & Tasks sheet, the "Refresh Workbook" button must be clicked on
the Kanban tab in order for the new data to be reflected throughout the workbook.
You can change Kanban status headings using dropdown list

"Dashboard"
See instructions for "Kanban" sheet to see how to apply filters. All charts on this tab are automated, provided the
"Refresh Workbook" button has been clicked on the Kanban tab after changes have been made to the Projects &
Tasks.
All content is Copyright material of Simple Sheets LLC.
http://www.simplesheets.co
© 2020 Simple Sheets LLC
All rights reserved.  The contents of this publication, including but not limited to all written material, content layout, images, formulas, an
No part of this publication may be modified, manipulated, reproduced, distributed, or transmitted without prior written permission of the p
 layout, images, formulas, and code, are protected under international copyright and trademark laws. 
ior written permission of the publisher, except in the case of certain noncommercial uses permitted by copyright law. 
Heading/Status Options Kanban Boards

Cancelled General
Pending Team #1
Research Team #2
In Progress Team #3
Completed Team #4
Testing Team #5
Projects Team Members

Project #1 Joe
Project #2 Sam
Project #3 Brenda
Project #4 David
Project #5 Michael
Project #6 Elizabeth
Project #7
Project #8
 Task Name Kanban Board Project Assigned To

Task 1 General Project #4 Joe

Task 2 Team #1 Project #3 Sam
Special Task 1 Team #3 Project #4 Joe
Special Task 2 Team #1 Project #4 David
Task 4 Team #4 Project #3 Brenda
Task 5 Team #4 Project #4 Michael
Special Task 3 General Project #1 Sam
Task 7 Team #1 Project #2 Joe
Task 8 Team #5 Project #5 Michael
Task 9 Team #1 Project #1 Michael
Task 10 Team #2 Project #2 David
Task 11 Team #2 Project #5 Sam
Task 12 General Project #2 Joe
Task 13 General Project #5 Elizabeth
Task 14 Team #3 Project #1 Sam
Task 15 Team #1 Project #2 Brenda
Special Task 4 Team #2 Project #5 Elizabeth
Task 16 Team #5 Project #2 David
Task 17 Team #4 Project #3 David
Task 18 Team #3 Project #3 Michael
Task 19 Team #2 Project #4 Sam
Task 20 Team #4 Project #3 Sam
Task 21 General Project #5 Brenda
Task 22 Team #1 Project #6 Joe
Task 23 General Project #1 Sam
 Tasks to be
Priority Start Date Due Date Overdue Status
completed

Low 4/2/2020 1/14/2021 Yes Research 10

Medium 1/21/2020 10/31/2020 Yes Testing 10
High 4/19/2020 8/1/2020 Yes Pending 10
Low 1/10/2020 11/19/2020 Yes In Progress 10
Medium 5/17/2020 11/9/2020 Yes In Progress 10
High 2/18/2020 9/14/2020 Yes Pending 10
Low 2/2/2020 12/1/2020 Yes Cancelled 10
Low 4/9/2020 2/16/2021 Yes Pending 10
High 5/7/2020 2/6/2021 Yes Completed 10
Medium 4/1/2020 7/24/2020 Yes Completed 10
Medium 3/20/2020 2/7/2021 Yes In Progress 10
Medium 1/12/2020 12/12/2020 Yes In Progress 10
Medium 2/19/2020 7/15/2020 Yes Completed 10
Medium 1/28/2020 10/13/2020 Yes In Progress 10
Low 3/12/2020 12/28/2020 Yes Research 10
High 4/6/2020 12/5/2020 Yes Pending 10
High 5/14/2020 3/5/2021 Yes In Progress 10
Low 2/12/2020 9/1/2020 Yes Research 10
Medium 3/7/2020 10/5/2020 Yes In Progress 10
High 1/16/2020 12/1/2020 Yes Pending 10
Low 4/1/2020 11/20/2020 Yes In Progress 10
High 10/2/2021 11/10/2021 Yes Cancelled 10
Medium 9/28/2021 10/12/2021 Yes Research 10
High 6/12/2021 7/1/2021 Yes Pending 10
Low 10/1/2021 10/20/2021 Yes Research 10
Actually Tasks
Remain Tasks % Progress
Done

2 8 20%
1 9 10%
3 7 30%
5 5 50%
4 6 40%
2 8 20%
5 5 50%
4 6 40%
4 6 40%
5 5 50%
3 7 30%
6 4 60%
7 3 70%
8 2 80%
9 1 90%
1 9 10%
5 5 50%
4 6 40%
5 5 50%
2 8 20%
4 6 40%
7 3 70%
2 8 20%
8 2 80%
6 4 60%
 Research Completed Cancelled

Task 1 Task 12 Special Task 3

Assigned to: Joe Assigned to: Joe Assigned to:
Priority: Low Priority: Medium Priority:
Due Date: 1/14/2021 Due Date: 7/15/2020 Due Date:

Assigned to: Assigned to: Assigned to:

Priority: Priority: Priority:
Due Date: 12/28/2020 Due Date: 2/6/2021 Due Date:

Assigned to: Assigned to: Assigned to:

Priority: Priority: Priority:
Due Date: 9/1/2020 Due Date: 7/24/2020 Due Date:

Assigned to: Assigned to: Assigned to:

Priority: Priority: Priority:
Due Date: 10/12/2021 Due Date: Due Date:

Assigned to: Assigned to: Assigned to:

Priority: Priority: Priority:
Due Date: 10/20/2021 Due Date: Due Date:

Assigned to: Assigned to: Assigned to:

Priority: Priority: Priority:
Due Date: Due Date: Due Date:

Assigned to: Assigned to: Assigned to:

Priority: Priority: Priority:
Due Date: Due Date: Due Date:

Assigned to: Assigned to: Assigned to:

Priority: Priority: Priority:
Due Date: Due Date: Due Date:
Assigned to: Assigned to: Assigned to:
Priority: Priority: Priority:
Due Date: Due Date: Due Date:

Assigned to: Assigned to: Assigned to:

Priority: Priority: Priority:
Due Date: Due Date: Due Date:

Assigned to: Assigned to: Assigned to:

Priority: Priority: Priority:
Due Date: Due Date: Due Date:

Assigned to: Assigned to: Assigned to:

Priority: Priority: Priority:
Due Date: Due Date: Due Date:

Assigned to: Assigned to: Assigned to:

Priority: Priority: Priority:
Due Date: Due Date: Due Date:

Assigned to: Assigned to: Assigned to:

Priority: Priority: Priority:
Due Date: Due Date: Due Date:

Assigned to: Assigned to: Assigned to:

Priority: Priority: Priority:
Due Date: Due Date: Due Date:

Assigned to: Assigned to: Assigned to:

Priority: Priority: Priority:
Due Date: Due Date: Due Date:

Assigned to: Assigned to: Assigned to:

Priority: Priority: Priority:
Due Date: Due Date: Due Date:

Assigned to: Assigned to: Assigned to:

Priority: Priority: Priority:
Due Date: Due Date: Due Date:

Assigned to: Assigned to: Assigned to:

Priority: Priority: Priority:
Due Date: Due Date: Due Date:

Assigned to: Assigned to: Assigned to:

Priority: Priority: Priority:
Due Date: Due Date: Due Date:

Assigned to: Assigned to: Assigned to:

Priority: Priority: Priority:
Due Date: Due Date: Due Date:

Status Comp TaAPrDay Month Year DaKPrOverdue

1 Cancelled CancelSpSLo 1 12 2020
### GPr 0
TaSHi 1 12 2020
### TPr 0.5
1 Completed ComplTaJMe 10 11 2021
### GPr 0.7
TaMHi 15 7 2020
### TPr 0.7
TaMMe 6 2 2021
### TPr 0.4
1 In Progress In Pro SpDLo 24 7 2020
### TPr 0.5
SpEHi 19 11 2020
### TPr 0.5
TaDMe 5 3 2021
### TPr 0.5
TaSMe 7 2 2021
### TPr 0.3
TaEMe 12 12 2020
### GPr 0.6
TaDMe 13 10 2020
### TPr 0.8
TaSLo 5 10 2020
### TPr 0.5
TaBMe 20 11 2020
### TPr 0.4
1 Pending Pendi SpJHi 9 11 2020
### TPr 0.4
TaBHi 1 8 2020
### TPr 0.3
TaMHi 5 12 2020
### TPr 0.1
TaJHi 1 12 2020
### TPr 0.2
TaMHi 1 7 2021
### TPr 0.8
TaJLo 14 9 2020
### TPr 0.2
1 Research ReseaTaJLo 16 2 2021
### GPr 0.4
TaSLo 14 1 2021
### TPr 0.2
TaDLo 28 12 2020
### TPr 0.9
TaBMe 1 9 2020
### GPr 0.4
TaSLo 12 10 2021
### GPr 0.2
1 Testing TestinTaSMe 20 10 2021
### TPr 0.6
1 (empty) (empt(e((e 31 10 2020
### ((e 0.1
 Cancelled Testing In Progress

Special Task 3 Task 2 Special Task 2

Sam Assigned to: Sam Assigned to: David
Low Priority: Medium Priority: Low
12/1/2020 Due Date: 10/31/2020 Due Date: 11/19/2020

Assigned to: Assigned to:

Priority: Priority:
11/10/2021 Due Date: Due Date: 3/5/2021

Assigned to: Assigned to:

Priority: Priority:
Due Date: Due Date: 2/7/2021

Assigned to: Assigned to:

Priority: Priority:
Due Date: Due Date: 12/12/2020

Assigned to: Assigned to:

Priority: Priority:
Due Date: Due Date: 10/13/2020

Assigned to: Assigned to:

Priority: Priority:
Due Date: Due Date: 10/5/2020

Assigned to: Assigned to:

Priority: Priority:
Due Date: Due Date: 11/20/2020

Assigned to: Assigned to:

Priority: Priority:
Due Date: Due Date: 11/9/2020
Assigned to: Assigned to:
Priority: Priority:
Due Date: Due Date:

Assigned to: Assigned to:

Priority: Priority:
Due Date: Due Date:

Assigned to: Assigned to:

Priority: Priority:
Due Date: Due Date:

Assigned to: Assigned to:

Priority: Priority:
Due Date: Due Date:

Assigned to: Assigned to:

Priority: Priority:
Due Date: Due Date:

Assigned to: Assigned to:

Priority: Priority:
Due Date: Due Date:

Assigned to: Assigned to:

Priority: Priority:
Due Date: Due Date:

Assigned to: Assigned to:

Priority: Priority:
Due Date: Due Date:

Assigned to: Assigned to:

Priority: Priority:
Due Date: Due Date:

Assigned to: Assigned to:

Priority: Priority:
Due Date: Due Date:

Assigned to: Assigned to:

Priority: Priority:
Due Date: Due Date:

Assigned to: Assigned to:

Priority: Priority:
Due Date: Due Date:

Assigned to: Assigned to:

Priority: Priority:
Due Date: Due Date:
 Pending

Special Task 1
Assigned to: Joe
Priority: High
Due Date: 8/1/2020

Assigned to:
Priority:
Due Date: 12/5/2020

Assigned to:
Priority:
Due Date: 12/1/2020

Assigned to:
Priority:
Due Date: 7/1/2021

Assigned to:
Priority:
Due Date: 9/14/2020

Assigned to:
Priority:
Due Date: 2/16/2021

Assigned to:
Priority:
Due Date:

Assigned to:
Priority:
Due Date:
Assigned to:
Priority:
Due Date:

Assigned to:
Priority:
Due Date:

Assigned to:
Priority:
Due Date:

Assigned to:
Priority:
Due Date:

Assigned to:
Priority:
Due Date:

Assigned to:
Priority:
Due Date:

Assigned to:
Priority:
Due Date:

Assigned to:
Priority:
Due Date:

Assigned to:
Priority:
Due Date:

Assigned to:
Priority:
Due Date:

Assigned to:
Priority:
Due Date:

Assigned to:
Priority:
Due Date:

Assigned to:
Priority:
Due Date:
 This shape represents a table slicer. This shape represents a table slicer. Table slicers This shape represe
Table slicers are not supported in this are not supported in this version of Excel. If the Table slicers are no
version of Excel. If the shape was shape was modified in an earlier version of version of Excel. I
modified in an earlier version of Excel, Excel, or if the workbook was saved in Excel modified in an earl
Status
or if the workbook was saved Taskin Name
Excel Assigned
2007 or earlier, the slicerTo Priority
can't be used. or if the workbook
2007 or
Cancelled earlier, the slicer can't
Specialused.
be Task 3 Sam Low 2007 or earlier, the
Task 20 Sam High
Completed Task 12 Joe Medium
Task 8 Michael High
Task 9 Michael Medium
In Progress Special Task 2 David Low
Special Task 4 Elizabeth High
Task 10 David Medium
Task 11 Sam Medium
Task 13 Elizabeth Medium
Task 17 David Medium
Task 19 Sam Low
Task 4 Brenda Medium
Pending Special Task 1 Joe High
Task 15 Brenda High
Task 18 Michael High
Task 22 Joe High
Task 5 Michael High
Task 7 Joe Low
Research Task 1 Joe Low
Task 14 Sam Low
Task 16 David Low
Task 21 Brenda Medium
Task 23 Sam Low
Testing Task 2 Sam Medium
(empty) (empty) (empty) (empty)
This shape represents a table slicer. This shape represents a table slicer.
Table slicers are not supported in this Table slicers are not supported in
version of Excel. If the shape was this version of Excel. If the shape
modified in an earlier version of Excel, was modified in an earlier version
Due
or Date
if the workbook was Kanban
saved inBoard
Excel Project
of Excel, or if the SUM of %was
workbook ProgressStatus
2007 or
12/1/2020 earlier, the slicer can't
General be used. saved in
Project #1Excel 2007 or earlier, the 50% Cancelled
11/10/2021 Team #4 slicer can't
Project #3 be used. 70%
7/15/2020 General Project #2 70% Completed
2/6/2021 Team #5 Project #5 40%
7/24/2020 Team #1 Project #1 50%
11/19/2020 Team #1 Project #4 50% In Progress
3/5/2021 Team #2 Project #5 50%
2/7/2021 Team #2 Project #2 30%
12/12/2020 Team #2 Project #5 60%
10/13/2020 General Project #5 80%
10/5/2020 Team #4 Project #3 50%
11/20/2020 Team #2 Project #4 40%
11/9/2020 Team #4 Project #3 40%
8/1/2020 Team #3 Project #4 30% Pending
12/5/2020 Team #1 Project #2 10%
12/1/2020 Team #3 Project #3 20%
7/1/2021 Team #1 Project #6 80%
9/14/2020 Team #4 Project #4 20%
2/16/2021 Team #1 Project #2 40%
1/14/2021 General Project #4 20% Research
12/28/2020 Team #3 Project #1 90%
9/1/2020 Team #5 Project #2 40%
10/12/2021 General Project #5 20%
10/20/2021 General Project #1 60%
10/31/2020 Team #1 Project #3 10% Testing
(empty) (empty) (empty) (empty)
COUNTA
Kanban of TasHigh
Board Priority
1 Low
General
Team
This#1
#2
shape represents 1 Medium
2
a table 2
slicer.
COUNTA
Assigned
Brenda
David of TasPriority
To High 1
Team
Table#3slicers are not2supported1 in this Elizabeth 1
version
Team #4 of Excel. If 2the shape was 2 Tasks Priority by Kanban Board
Joe 2
modified
This#5
Team shapeinrepresents
an earlier1 aversion
table of Excel,
1 slicer. Michael 3
or
Table slicers are not supported inExcel
if the workbook was saved in this General0 2 Sam 2
2007 or of
earlier, 1
version Excel.the
If slicer can'twas
the shape be used.
(empty)
modified
This shapeinrepresents
an earlier aversion of Excel,
table slicer.
or Team #1 1 2 2
Table slicers are not supported inExcel
if the workbook was saved in this
2007
versionor of
earlier,
Excel.the
If slicer can'twas
the shape be used. Prio
Team #2 1 2 1

Kanban Board
modified
This shapeinrepresents
an earlier aversion of Excel,
table slicer. Med
or
Table slicers are not supported inExcel
if the workbook was saved in this Low
2007 or earlier, the slicer can't be used. Team #3 2 0 1
version of Excel. If the shape was
modified in an earlier version of Excel,
This shape represents a table slicer.
or if the workbook was saved in Excel Team #4 2 2 0
Table slicers are not supported in this
2007 or earlier, the slicer can't be used.
version of Excel. If the shape was
modified in an earlier version of Excel, Team #5 1 0 1
or if the workbook was saved in Excel
2007 or earlier, the slicer can't be used. 0 1 2 3 4 5 6

Tasks Priority by Status

8

5
5 1
4 0

2 0 4

1 0 2 2 0
1 1 1
0 0 0 0
Cancelled Completed In Pending Research Testing (empty)
Progress
Status
 Low 2 Medium 2 (empty) COUNTA
Cancelled of TasHigh
Status Priority 1
1 Completed 1
anban Board 2 1 Tasks Priority by Members
In Progress 1
1 Pending 5
4 2 Brenda0 2 Research
Testing
David 2 0 2
2 (empty)
Priority High Elizabeth0 1 Low
Medium Assigned To (empty)
Low Joe 2 0 1 Medium

Michael0 1
0
Sam 4 0 2

(empty)0

4 5 6 0 1 2 3 4 5 6 7

by Status Priority Analysis

1 High
Medium
0 Low
(empty)
Medium
Low
(empty)

1
0 0
earch Testing (empty)
 Low 1 Medium (empty) Priority
High
Low COUNTA of Task
8 Name
2 Medium 9
ers 2 5 (empty)
1
4 1
1

Low
(empty)
Medium

6 7

High
Low
Medium
(empty)
UNTA of Task Name