IT Employment

Ask something
Discussion Locked

MS Project Flags

0 helpful
3 replies

by abednego

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
Can anyone tell me how to use functions in MS Project to create graphical indicator flags (red, yellow, green lights) to indicate the status of tasks (whether they are behind schedule, critically behind schedule or on time). I know how to create custom fields and graphical indicators, but I can't figure out how to use the functions that come with MS Project in order to set up the kind of test I described above. Thanks

3 replies

by kees.valkenswaard

This is a real bargain for 150 points! About 750 to 1000 would be fair.
Just for once:

Microsoft does not provide much information in the help files. At least I could not find what I needed. However, put the following formula in e.g. Number11.
NOTE Your system could use , (comma) in stead of ; (semicolon) as list separator.

IIf([Baseline Finish]=1;IIf([Critical];3;2);1);0)
The result is:
0 = no baseline
1 = will finish the same day as baseline
2 = will finish at least one (working) day after baseline, not critical task
3 = finish at least one (working) day after baseline, critical task

It seems as if the old, dangerous trick of putting a high value is used for no baseline. The system will likely understand the date. Else change to the silly, old-fashioned US method “12-31-2099”
You need the function ProjDurValue to convert minutes to days.
I would use the red smiley for >= 3, below the blue one for >= 2, the yellow happy one for >=1 and a ? (question mark) for <1 . The latter as a warning that for this task no baseline has been saved. Good luck!

by kees.valkenswaard

It is hopefully clear that no space is required in the name Baseline in [Baseline Finish] as first argument of the fuction ProjDateDiff
This was due to the pasting in the box.

by kees.valkenswaard

Your answer is now up for two months. Are you going to accept it or providing additional comment? Why do we answer questions?

If you would like to mail me at kees.valkenswaard@planet.nl do not forget to put Q&A as part of the subject line. Else the message would be deleted.

This discussion is closed to new replies.