Using graphical indicators

[RC]

Hello,

I am trying to accomplish the following using graphical indicators.

- for tasks 100% complete= the green circle
- for finish later than finish1 = the red circle
- for finish at least 6 days before finish1 = white circle
- for finish within 5 days of finish1= yellow smiley

So far I've done the following in the customizing fields portion.

Duration4 formula = ProjDateDiff([Finish],[Finish1])

Graphical indicators
is less than, 0d = red circle
greater than or equal to, 6d = white circle
is within, 0d, 5d = yellow circle

It doesn't seem possible to get the 100% complete part using a
duration field - is there a way to get all 4 conditions in?

Thank you for any advice!

 

[Jim Aksel]

You cannot test for Complete directly in a Duration Field. The custom
duration field must evaluate to a measure of time.

Try using a custom number field. Off the top of my head, I'd approach it
this way:
Create a formula

IIf([% Complete]="100",100,cint(projDateDiff([Finish],[Finish1])))

What this formula does is returns the value "100" if the status of the task
is complete, otherwise it returns the difference between the two dates in
minutes. Be careful to select a value for 100% complete that would never be
a number of minutes late/early. Since "cint" is converting to an integer, it
should be giving you whole days in minutes 0, 480, 960, etc. You may want to
use 100%Complete = 1.5 or some fraction so you know it will never match the
conversion.

You could also cint(xxx)/480 and you will get an integer number of days
(assuming an 8 hour work day).

You can now use your graphical indiators based on the number of minutes (or
divide by work minutes per day (480) for days). Set another criteria so that
if it is exactly 100, then return the icon you want.

--
If this post was helpful, please consider rating it.

Jim

Visit http://project.mvps.org/ for FAQs and more information
about Microsoft Project

 

[RC]

Hi Jim,

Thank you for pointing me in the EXACT direction I needed! Using the
number field and your suggestions, I was able to use the graphical
indicators as the team desired.

RC