Using Kanban Boards in Microsoft Project

Introduction

There has been a lot written over the last year regarding Microsoft’s foray into the world of Agile Project Management by way of new improvements in Microsoft Project. This article provides an update based upon one of the latest versions. We’ll discuss what’s changed recently and provide a walkthrough on setting up and using the Kanban Board. For those more interested in Sprints and Scrum, please note that I plan to cover those topics in depth in a subsequent article.

What is a Kanban Board?

A Kanban Board is a technique that allows us to visualize and show how work moves from left to right. Each column on the board represents a stage of the overall process. To be more precise, the board gives up a visualization of the project. On a physical board, a team would pull cards (each card representing a task) from one column to another to show progress (left to right). The columns on the Kanban board represent the state/stage of the task.

Examples of stages include:

  • Waiting, Work in progress, and Completed
  • Backlog, Ready, Coding, Testing, Approval, and Done
  • Next, In Development, Done, Customer Acceptance, and Live

See https://en.wikipedia.org/wiki/Kanban_board for more information.

Checking Your Version of Microsoft Project

These Agile features are only available in the subscription version of Microsoft Project.   The basic features have been available since October 2017 in Version 1710 (Build 8625.2055), but some of the later features (search and % Complete for example) are very recent additions.  What you might see will depend on your exact version!

To check which version of Project you’re using, open Project, choose File, and then select Account. Under Product Information, you see the subscription version if you are using it, like so:

Microsoft Project Version Check
Microsoft Project Version Check

To check your current version, go to the About Project button. Here you can find the Version, Build number, and your update channel. You can see below that mine is set to Monthly Channel (Targeted).

If there are updates waiting to be installed for MS Project, this will be displayed next to the update button. In the image below you can see that there are no notifications, and therefore, I am already on the latest update available within the Monthly Channel (Targeted).

Assuming that you have a subscription to Project, and that you have a subsequent version to 1710, you’re ready to create a Kanban project.

Where’s My Kanban Button Gone?

If you’ve read other articles or have dabbled a little bit already with the Agile features of MS Project, you know that it’s important to be aware of the following user interface (UI) changes that Microsoft has made recently:

  1. The new Sprints Project template has replaced what was the Scrum Project
  2. The Kanban Project template has been removed, and all references to Kanban have been replaced by Task Board.
  3. The Agile button in the figure below, which allowed a user to choose the Agile methodology, has been removed also.

Whilst none of these changes affect the current level of functionality, it’s worth being aware as you may see older articles that reference these UI features.

It’s also worth stating again that these are UI features only; the functionality of the product remains the same.

Switching and Setting up the Task Board View

To use a Kanban Board, you need to select Task Board view. The Kanban features sit nicely alongside the traditional Waterfall features, so you can take an existing project and view it in a Kanban Board.

Open your project. Then, on the View tab, in the Task View section, select Task Board.

Switching and Setting up the Task Board View
Select the Task Board view

Your project tasks will display as boards in the Task Board view as shown below:

Task Board view
The Task Board View

In order for a project task to display in Task Board view, the Show on Board flag for the task must be set to Yes (this is the default setting), and this can be set by adding the Show on Board column to the Gantt Chart view. If you don’t want a task to be visible on the board, change the setting to No. Summary tasks will never be displayed on the board, as they facilitate the filtering option, and the flag has no impact for such tasks.

Task Board view, the Show on Board Flag
The Show on Board column in the Gantt Chart view

Setting up Column Names and Board Options

When you switch to the Task Board view, the first real choice you must make is whether to keep the default column names or change them to suit your process. I’m going to add in a new column called Quality assurance to my column list. To do this, I’ll follow the steps outlined below:

  1. Click on the Add New Column
Setting up Column Names and Board Options

2. Enter the column name, and then right-click on it to display the column options of renaming, deleting, or moving the column to the left or right.

display the column options

3. In this instance I’m going to move the column to the left and place it between Next up and In progress.

display the column options

4. The column names you enter here are mapped to a task field called Board Status, which can be viewed (and changed per task) in any task centric table.

5. One last thing to consider in your set up phase is this: decide whether moving the tasks between columns should update the % Complete field for each task. If you want this to happen, simply enter the % Complete to be assigned under each column header. Note that the default column of Done already has a % Complete set to 100.

6. If you don’t want to use the % Complete fields, then leave them unset and uncheck the Show % Complete Mapping option in the Task Board Tools Format tab.

Show % Complete Mapping

Entering Tasks

Now that the Task Board view has been set up correctly, it’s simply a case of entering tasks directly onto the board.

7. Click on the Add Task button, enter the task name, and click Add.

Entering Tasks

8. Continue adding tasks until you have a full list of tasks for your project.

list of tasks for your project.

The result is a flat list of task names. This is fine where we don’t have too many tasks, but projects have a habit of morphing and changing quite a bit, and so, we can organize these tasks using Summary tasks. In order to create Summary tasks, we switch away from the Task Board view and to the Task Sheet view.

9. Select Task Sheet from the View tab, Other Views menu.

Task Sheet

10. Insert Summary tasks in the usual manner, just as you would if you were setting up a standard “Waterfall” project. Typically, I do this by inserting tasks, and then then using the Indent button. By default, Summary tasks are set to be Auto Scheduled, whereas non-summary tasks are still Manually Scheduled.

 Insert Summary tasks in the usual manner

11. Once the Summary tasks have been entered, we can then begin to use the filtering options in the Task Board view. More on that later.

filtering options in the Task Board

 

 

Assigning Resources

One of the properties of a Kanban board is that it allows us to do simple resource assignments. We can easily (and visually) see who is performing or who owns each task or activity. Assigning resources can be performed in the Task Board view. For this project, I want to assign resources for the majority of tasks. Initially the list of resources will be blank, but are added by typing them into the Assign Resource dialog box. They will populate on the Resource Sheet. Note that once resources are assigned to tasks, the work value will be populated. This value can be viewed on the Task Board sheet.

12. Within the Task Board view, right-click on a task, and choose Assign Resources. Enter the resource name(s) into the Assign Resources dialog box, and click on the Assign Repeat this process for each task that you want to assign resources to.

Assigning Resources in Kanban Board

Modifying the Work Value

When resources are assigned to tasks, a work value is created for each task. If you want to modify this value because you are estimating work and tracking it, this is best done in the Task Sheet view.

13. From the Format tab on the Task Board view, select the Sheet button to display the Task Board Sheet. Alter the Work value as required for each task.

Modifying the Work Value

Filters and Searching

So far, I’ve entered a lot of data, including summary tasks and resources. If there are more than, say a dozen tasks (and let’s face it, if I just had a dozen tasks, I’d used Excel or Wunderlist), then it’s difficult to view all of these tasks on the Task Board view. This is where filtering and searching comes in. Use the Filter button to only display the tasks belonging to one or more Summary tasks, or associated with one or more resources. Having applied a filter, I can further refine my query by using the search button. The searching and filtering functions allow me to quickly find the tasks or resources that I’m interested in.

14. Select one or more Summary tasks, and one or more resources using the dropdown menus from the Filter The tasks displayed on the Task Board view are filtered accordingly.

Filters and Searching

15. Use the Search button to further refine the displayed task list within the Task Board. The search is applied to all tasks within the current filtered list, and searches both the task name and the resource name. The search is not case sensitive.

Search button to further refine the displayed task list within the Task Board.

 

Progressing Tasks

We’re now at the point where we can begin working on the tasks and therefore, progressing them on the Task Board. To do this, simply drag and drop the tasks from the Not Started column to the relevant columns on the right. If you have set a % Complete value for each column, then these percentages will be set for each task as you drop them into the column.

16. Drag the tasks to the relevant column as the tasks progress.

Progressing Tasks

 

Reports and Printing

One of the key requirements of any project manager is to provide timely and accurate reports. Microsoft has created two Task Board reports: one that focus on the task status, and another that focuses on the work status. Of course, these are in addition to all of the standard reports that are provided out of the box. You can use these reports as provided or use them as a basis for setting up your own customized reports.

The reports are available on the Report tab within the Task Boards button.

17. Navigate to the Report tab, and then click on the Boards – Task Status within the Task Boards reports button. Notice that the layout of the report can be easily changed. In this case, I have added the MPUG logo.

Reports and Printing in Kanban

18. Now navigate to the Boards – Work Status This report is more focused towards resources and who is doing what.

 Boards – Work Status

Both reports can be edited and printed (something you cannot do from the Task Board), and of course, are updated as the project is updated. One thing that I don’t like on either report is the Remaining Work Over Time and the Remaining Tasks Over Time graphs, as they just display invalid data unless I am prepared to finesse the project schedule somewhat, which, for a simple Kanban plan I wouldn’t be doing.

Summary

Within this article, I have explored using Microsoft Project to run a project using the Task Board, a.k.a. the Kanban board. This is probably one of the simplest methodologies open to us when managing a project, and you can see how I’ve managed to setup, enter, track, and comprehensively report on a project within a few steps.

Keep an eye out for my next article which will cover using the Scrum methodology within Project, and please feel free to download the associated .mpp plan that I used to produce the screen shots above by clicking here.

Written by Ben Howard
Ben Howard – Awarded Community Leader for his very popular and comprehensive UK web training series and has over 30 years of experience of implementing enterprise solutions for customers worldwide.  During that time, he’s worked for IBM, DELL, and Microsoft, as well as several smaller organisations. He now runs his own consultancy (Applepark Ltd), providing Project, Project Online and Power BI implementation and training services. He has been awarded the Microsoft Most Value Professional award for Project for the last 13 years, blogs semi-frequently at www.applepark.co.uk, produces video training for Pluralsight and his own YouTube channel, and finally was responsible for producing P2O, an application that exports tasks from Microsoft Project into Outlook.  You can catch him at ben@applepark.co.uk  
Share This Post
Have your say!
00
2 Comments
  1. Ben, comprehensive and thorough article; keep up the great work! Eric

  2. When you say “Don’t see this” do you mean the actual screen shot you posted at . The format of the actual screen isn’t important, it’s the functionality of MS Project which is important. I presume you have the agile features?

Leave a Reply