Graphical Indicators

[Debbie]

I am attempting to show if projects are on target for completion, approaching
their limit or if they are late. The code below is in a enterprise custom
task text field and in a enterprise custom project text field.

The formula is set with graphical indicators for On Target, Approaching
Limit, and Late. The enterprise custom project text field allows us to see
the indicators in project center while the enterprise custom text field
allows us to see the graphic indicators in a task detail view.

I did not write the code and have a glancing understanding of what it means.
What I do know is this: The formula works in the custom task field, but
does not work in the project text field. All of the graphical indicators
show as green in the project text field when they should be showing a mixture
of green, yellow, and red.

Why would it work in the task field but not in the project field? Any help
is deeply appreciated.

IIf(INT([Start]-date())>=5,"On Target",IIf(INT([Finish]-date())>5,Switch([%
Complete]<=100,"On Target"),IIf(INT([Finish])-date()>0 And
INT([Finish]-date())<=5,Switch([% Complete]<50,"Approaching Limit",[%
Complete]>50,"On Target"),IIf(INT([Finish]-date())=0,Switch([%
Complete]=0,"Late",[% Complete]>50,"Approaching Limit",[% Complete]=100,"On
Target"),Switch([% Complete]=100,"On Target",[% Complete]>25 And [%
Complete]<100,"Approaching Limit",[% Complete]<=25,"Late")))))

 

[tonyzink]

Hi Debbie --

I assume that you've inserted your project-level field into an
MSProject view... and this is causing your confusion...?

What you are seeing is expected behavior for project-level custom
fields.

A project-level field describes a project schedule overall, whereas a
task-level field describes individual tasks within a project schedule.
Keeping this in mind, if your project-level field is stating that your
project schedule is "Green" overall, then this will not change...
regardless of which task you may be looking at within the schedule.

Good luck!

Tony Zink
========================================
http://www.msprojectreporter.com
http://www.pmreporter.com
http://www.sharepointreporter.com
http://www.msofficereporter.com
http://www.dotnetreporter.com
========================================

 

[Debbie]

That is what I thought, although another member of my team was insistent that
I was wrong.

Thanks,

 

[Ignbell]

Debbie,
I know almost nothing about Formulas and Custom Fields, i tryed to
get the same thing working but i can´t even get the Formula you posted to
work.
Is there a posibility that you could tell me where i can get information on
how to do it step by step or where did you get your knowledge from?
Thanks a lot,
Nacio.