Trying to create a status notation in PWA on each project

[Dale]

We would like to create a status notation in PWA that would display the most
recent phase of a project that has been completed. Is there a way to have
this automatically detected and reported?

 

[Reid McTaggart]

There are a few ways to do this. Here is one. This is only a basic
approach. When I implement it, I usually make it more comprehensive and user
friendly by using some text fields and formulas, which allow for naming
phases instead of simply numbering them as in this example.

Create an Enterprise Task Number field to contain the phase designation for
each task.

Create an Enterprise Task Number field with a formula that returns the phase
number from the above field if the task is NOT 100% complete. If the task is
complete, the formula should return a large number, such as 99. Set this
field to Roll Up the Minimum value.

Create an Enterprise Project Text field with a formula that evaluates the
rolled up value of the above ETN field. If the value is 99, then the project
is complete. Otherwise, the value of the rolled up ETN field minus 1 is the
number of the last completed phase. If the valueof the roilled up ETN field
is 1, then no phases have been completed (assuming you start numbering phases
at 1).

Hope this helps.