Status Light Indicator

[mobileindy]

I have used Dale Howards FAQ to create status light indicators based upon
finish variance. However, we have a specific project that we want an
indicator that displays red if a task has not been started (i.e. no
%complete) and the plan date is greater than today's date.

Any help that anyone could give on this is much appreciated.

Thanks.

 

[Dale Howard [MVP]]

mobileindy --

You cannot set different criteria for different projects. The criteria you
specify for Graphical Indicators applies to all projects in the database.
In your case, I would recommend you create another custom field for the
specific purpose you seek. Hope this helps.

 

[mobileindy]

Dale,

Thanks for the feedback. I understand the need to have another custom
field. What I am struggling with is how to create the formula based upon
today's date being greater than the baseline date then turning the status red.

Thanks.

 

[Dale Howard [MVP]]

mobileindy --

OK. How about this:

1. Create a custom enterprise Task text field and rename it as "Is Current"
or something like that.
2. In the field, enter the following formula:

IIf([Current Date]>[Baseline Start],IIf([%
Complete]=0,"Behind","Current"),"Current")

3. Set the Graphical Indicator tests as follows:

equals Behind Red Flag indicator
equals Current Green Flag indicator

Hope this helps.