Today I’m going to show you how to make a traffic light which will show you when your work has exceeded planed or Baselined work in MS PROJECT 2019!
I’m going to create Simple Project with one Task:
I’m also going to create two different Resources:
And I’m going to assign john to this Task:
I put two extra columns just to show you how will it work: Baseline work, and Work.
I’m going to save the Baseline now:
And I will get:
As you can see Baseline Work and Work are the same for now. I want to make a Traffic light which will show:
- If Baseline work is less than Work – red light
- If Baseline work is equal Work – yellow light
- If Baseline work is greater than Work – green light
To do that I will create custom field called – Baseline vs work:
No. I will show this Traffic light on the screen:
This is very good way to show when you are exceeding work from planned, especially when you have a lot of Tasks in your Project.
and I will get:
One hint! Values like 0,1 or 2 can be confusing because you should remember them (0 is red, 1 is yellow, etc.). Instead of that I could put “red”, “yellow” and “green” in IIf formula, and the result will be the same, but more meaningful when you filter Task on that condition.