Traffic light Indicators

[atouchet]

I would like to add a column within a Gantt view that display traffic light
indicators based on the following parameters;

If Finish Date is >10 when compared to Finish Date, symbol is Red
If Finish Date is less than or equal to 2, symbol is Green
Everything else, 3 – 9, is yellow.

I reviewed the message, Subject: How do I set up traffic light indicators in
a Gantt chart? 7/10/2005 5:48 AM PST, but when I performed those steps, the
indicators were inaccurate due to when I pasted the information from the
"Finish Date" column, a date was placed in the variable field within the
graphical indicator area and the indicators were based on that date.

 

[atouchet]

The parametrs should be:

If Baseline Finish Date is >10 when compared to Finish Date, symbol is Red
If Baseline Finish Date is less than or equal to 2, when compared to Finish Date, symbol is Green
Everything else, 3 – 9, is yellow.

 

[Dale Howard [MVP]]

atouchet --

Use the [Finish Variance] field as your formula in a custom Duration field.
The Finish Variance field automatically calculates the difference between
the current Finish date and the original Baseline Finish date. Then use the
following rules to generate the stoplights:

Is greater than 10d Red
Is greater than 2d Yellow
Is less than or equal to 2d Green

Hope this helps.