Task information rolled up to Project Center View

R

Rob Stewart

Hi there,
I'll first describe my ideal scenario, and then go through my intended steps
to acheive it..

Ideal scenario:
Looking at a Project Center View, be able to see a number of COLUMNS which
show the duration variances from specified milestones within each project.
(I.E. DEVELOPMENT MILESTONE +3weeks, or DEPLOYMENT MILESTONE -2 Weeks)

I first thought about creating a number of Enterprise Custom Task Fields
named "DEVELOPMENT MILESTONE" , "DEPLOYMENT MILESTONE", and so on, and
somehow having only the corresponding milestone task be calculated, but got
stuck trying to deal with the roadblock between Enterprise Project, and
Enterprise Task fields, and the Enterprise Task Fields' inability to be
displayed on Project Center Views.

So my question is:
"What is the best way to display specific milestone task information on a
Project Center View?"

Thanks much!
-RS
 
M

Matt Stevenson (UK)

Hi Rob,

I think you're going down the right path. (can't show task outline codes in
Project Center views) and setting up a Project level field to display the
progress of a particular milestone type.

We did this for a particular customer that have 5 key milestones along the
project lifecycle and wanted a project center view of when they were complete
(ontime, within a variance tolerance or above tolerance)

We configured 5 Task custom fields which use IIF formulas to give a value
(when the task %complete = 100% and if Finish = Baseline Finish then = 1 or
if > Baseline Finish + Tolerance then = 2 etc. and set them a summary rollup
at Max - so we have the worst delivery per milestone type.

Then setup 5 Project Custom Fields which = Task Custom Field, and put this
in the Project Center view.

This was our solution, there maybe others...
 
R

Rob Stewart

Matt,
Thanks for the info.

Could you post your IIF formula ?

Many thanks!
-RS
 
Top