Traffic Lights in MS Project

Project 2013, Project 2010, Project 2007 Note

Microsoft Project Indicators. Traffic Lights in MS Project. I believe that this method will work in previous versions of MS Project because I have used it for many years!

I have many Microsoft Project blogs and videos! Just follow the links!

Adding Microsoft Project Indicators – Graphical Indicators on MS Project Tasks

Traffic Lights – Microsoft Project Indicators – in MS Project 2016. I am going to suggest two different methods for achieving this. An easier method first, but not one that I believe to be the correct method if you are using MS project properly. The second method requires a baselined project.

Easy Method to Add Indicators

This method is easier because it does not need the project to be baselined – something that people don’t like to admit they misunderstand. However, it does require a manual status input on every task – and although this is not a bad thing in itself, if you have many hundred tasks it becomes time consuming.

In a new project, create three automatically scheduled tasks. I’ve given them different durations for variety!

List of three tasks

List of three tasks

Insert a new field Text30 (Text 30 is suggested as Text1, Text2 are often used first).

Insert Text 30

Insert Text 30

Use “Look Up” in Custom Fields to constrain the information that can be inserted in these fields.

Custom Fields

Custom Fields

Custom Fields Look Up

Custom Fields Look Up

Tip: You can use this “Look Up” technique with other Text fields for many reasons – text fields for set suppliers, contractors etc.

Rename the field to be “Task Status” (Status cannot be used as it is already a pre-defined MS Project database field).

Rename a Custom Field

Rename a Custom Field

Now you can set each task to show a different task status.

Using the new Custom Field

Using the new Custom Field

Now add a second new column (Text29) (I renamed this to “Traffic Light”) and by using Custom Fields set its formulae to equal Text30.

Setting a Formulae in Custom Fields

Setting a Formulae in Custom Fields

Use the Custom Fields to set the graphical indicators for Text29 as shown below.

Setting Graphical Indicators

Setting Graphical Indicators

By changing the new “Task Status”, the graphical indicator “Traffic Light” now changes.

Traffic Lights in MS Project

Traffic Lights in MS Project

Correct Method to Add and Use Indicators

A good project is baselined, and the MS Project database will hold values for planned (baselined) start and actual start dates for each task. A reminder on baselining is covered in this blog article.

Therefore it is unnecessary to manually determine each individual task status as shown above. However, MS project is just a computer. Looking at each task individually, and considering the resources, dependencies, and risks is benefit a human can bring to the planning party!

Using the same sort of method as above, we are going to take a similar project and baseline it, and then compare the actual and planned Start dates.

First create a project, and set the baseline.

Baselined Traffic Lights

Baselined Traffic Lights

Change to the Variance Table and add a custom field Date1 and set the formulae to be equal to Start. I’m using the variance table because it will show the Actual and Baselined Start columns.

Setting Custom Field Formulae

Setting Custom Field Formulae

Set the graphical indicators to show a graphic if the Actual Start is less then, equal to, or greater than the Baseline Start.

Graphical Indicators for Traffic Lights

Graphical Indicators for Traffic Lights

Microsoft Project Indicators

The result should show Traffic Lights  – Microsoft Project Indicators – that change when the actual start dates for tasks change.

Microsoft Project Indicators

Traffic Lights on Baselined Project

Tip: You can also use this technique on Planned and Actual Finish dates or other MS Project fields.

Tip: You can now use “Sort” and “Filter” to bring all the late tasks together for easier reporting.

However you do this, a visual indicator is always a good thing. Automation is good, but human input is always required.  Please remember that you are the Project Manager, not MS Project!

I have many Microsoft Project blogs and videos! Just follow the links!

If you’ve enjoyed this blog post, then please share it using the icons below. Thank you!

 


Posted On: 1st September 2017

Join the conversation