not started yet + graphical indicators

[D.]

Hi guys,

I set up a % complete graphical indicator that works rather well. However
even when a task has not started yet, it still triggers a 'red' indicator. I
'd like to find a way to avoid that and have a red signal ONLY when a task is
started and delayed. Any ideas?

Thanks,


D.

 

[Jan De Messemaeker]

What criteria do you use for the indicators?

 

[D.]

Hi Jan,

I use (% complete) as a formula
and
Is greater than equal to 80: green
Is within 25,80: orange
Is less than or equal to 25: red

Unfortunately this formula counts tasks not started as 'red' too.

Any suggestions?




D.

 

[Jan De Messemaeker]

Hi,

First, this doesn't show whether a task is delayed (for starters, it has no
comparison to a should-be date - baseline f.i. - ) it just shows the rate of
completion
And how about
Is within 0.01,25: red
Equals 0: no indicator

HTH

 

[D.]

Doesn't really help: all tasks that have '0 completion' have now no graphical
indicator, including tasks with past due dates...
Really, it seems to me that what I need is some additional line that says:
If todays's date is inferior to 'planned start date' then: no graphical
indicator. Does that make sense?

Thanks for your continued interest in my problem,

 

[D.]

Anybody? Come on guys, this shouldn't be so hard....


D.

 

[Jan De Messemaeker]

Hi D.,

If it doesn't work on the graphical indicators directly, maybe use a number
field with a formula (if conditions can be nested in a formula)
HTH

 

[D.]

Hi Jan,

Thanks for your reply. I am currently using a number field but I do have a
hard time coming up with the formula. I end up having a lot of syntax
errors...Any idea of a date formula that would work in a number field that in
essence would say "if current date < to start date: no indicator"


Thanks again,


D.

 

[Jan De Messemaeker]

Hi D.

A formula that works in a number field is for instance
IIf(([Start]<[Current Date]),1,0)
Then you asign whatever graphical indicator to the values.
HTH