Custimizing Enterprise Fields - Progress Indicators

[Scott]

I am looking for some help, guidance and/or direction on working with
Enterprise Custom Fields. I have requirements to create a calculated
progress indicators "Green, Yellow and Red (Stoplight)" leveraging the MS
Project graphical indicator feature that will represent late projects and
tasks. I have the psuedo code straight but am having difficulty creating
this feature leveraging a custom enterprise field. Here is the psuedo code:

At the Project Level,
If “finish date†< = “baseline finish dateâ€, then Green Indicator (On
schedule), else
If “finish date†> “baseline finish dateâ€, then Yellow Indicator (Late), else
If “finish date†> “baseline finish date + 14 daysâ€, Red Indicator (Late by
more than 14 days)

At the Task Level
If “finish date†< = “baseline finish dateâ€, then Green Indicator (On
schedule), else
If “finish date†> “baseline finish dateâ€, then Yellow Indicator (Late), else
If “finish date†> “baseline finish date + 28 daysâ€, Red Indicator (Late by
more than 28 days)

I also need to create a custom enterprise field at the project level that
will allow the project manager to select their own "Stoplight" status.

All of my attempts have returned errors. I have found several references on
this discussion group and on the internet, but nothing that has given me a
good example of how write these formulas.

Has anyone done this? Does anyone have a good code example that I can reuse
or can give me a good push in the right direction?

 

[Dale Howard [MVP]]

Scott --

In the future, please post your Project Server questions to the
microsoft.public.project.server newsgroup, as this newsgroup is devoted to
the Microsoft Project desktop application only. To answer your questions,
refer to the following FAQ for an in-depth example of how to handle a
situation such as yours:

http://www.projectserverexperts.com/Shared Documents/CreateStoplightIndicators.htm

Hope this helps.

--
Dale A. Howard [MVP]
Enterprise Project Trainer/Consultant
http://www.msprojectexperts.com
http://www.projectserverexperts.com
"We wrote the books on Project Server"