Link to home
Start Free TrialLog in
Avatar of avvweb
avvweb

asked on

Iconized status in Project 2007/2010

How can I see an icon with the current status of an activity? I've seen books and tutorials with the "traffic light" like indicator.

Thanks
ASKER CERTIFIED SOLUTION
Avatar of Dr. Thomas Henkelmann
Dr. Thomas Henkelmann
Flag of Germany image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of leopolde
leopolde

If you'd like to use earned value as a method of tracking the progress of your project, you might create a graphical indicator using fields like SPI (Schedule Performance Index) or SV% (Schedule Variance Percent).  I believe this is a more accurate way of measuring your project performance.

For this to work you need to have a baseline, and resources should have a Standard Rate.  If the rate is not available I use $1 (you might try this and verify if it works for you).

The formula for the custom field might look like:
IIf([Baseline Finish]<>ProjDateValue("NA"),IIf([SV%]<-20,"Significantly behind schedule",IIf([SV%]<0,"Behind schedule","On schedule")),"No base line")

Please note that I also included a check for the existence of a baseline.

You can then configure the graphical indicators to show red flag for "Significantly behind schedlue", yellow flag for "Behind schedule", green flag for "On schedule", and white flag for "No baseline".

Hope this helps.