Exception Status Indicator EPM 2007

[nsco2]

I need to create a Project level custom field which displays an
indicator for projects that require publishing. Basically the EPM
administrator needs to be able to see a dashboard of projects where
the last published has exceeded the current date by more than 5 days.
Is this possible? If so does anyone have a formula appropriate?

thanks in advance

 

[Andrew Lavinsky]

I can get you part of the way there, but not make it fully automatic....

1) Expose the Last Published field in a Project Center view
2) You may also choose to expose the Status Date in the Project Center view
as well, as that allows you to see if the PM's are updating their projects
appropriately.
3) You can then sort the view on Last Published.
4) To filter though, you would have to create a new filter each time you
change the date, as to my knowledge, you can't make the value of the filter
an expression such as "[Today]-14" or something like that. You can turn
on the Autofilter which easily allows you to do the same thing.

That's easy enough, and should get you the data you need.

-A