MS Project 2003 Task graphical indicators for progress (red, green)

Hi, I am trying to create red/yellow/green indicators that change based on a task's progress, e.g. blank if not due for more than 10days, yellow if due within 10days, red if overdue, green if % Complete is 100.
I did it by accident a couple of years ago, but can't reporduct it now. I want to base it on today's date, e.g. Now(), Date() functions in Customise Fields...? and compare to Finish date and % Complete columns
tcudmoreAsked:
Who is Participating?
 
Dr. Thomas HenkelmannConnect With a Mentor Director Consulting ServicesCommented:
Hi,

you can do with a formula for a number field and a graphical indicator.

- Insert the "Number1" column and right click, then on "Customize fields"
- Click on formula and copy this: IIf([Finish]>dateadd("d";10;now());0;IIf([Finish]>now() And [Finish]<dateadd("d",10,now()),1,IIf([Finish]<now(),IIf([% Complete]<100,2,3),4)))
- If you get an errors (known issue in 2003) after clicking OK, please replace the semicolon with comma
- Click on Graphical indicators
- in the "Test for Number1" column select "Equals", in "Value(s)" enter "0", in "Image" leave blank
- repeat this for values 1, 2 and 3 and select your desired icon/color in the "Image" column

0: not due
1: due
2: overdue
3: 100% complete

Regards

Thomas
0
 
xtermieCommented:
If you are using project server, check this out on how to do sorta of what you want
http://www.projectserverexperts.com/ProjectServerFAQKnowledgeBase/CreateStoplightIndicators.aspx
0
 
tcudmoreAuthor Commented:
I've requested that this question be deleted for the following reason:

Not needed
0
 
Dr. Thomas HenkelmannDirector Consulting ServicesCommented:
Well, asking for a solution, receiving a fully functional description and then claiming it's not needed just doesn't work!
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.