How to get Project global Schedule status from Tasks Schedule Stat

[jpa]

Hi
I am using PS2007 SP1.
I created a TASK custom field#1 indicating task schedule progress (eg: "on
time", "late", "done") with corresponding flags indicators. This works fine.
Now I'd like to create a PROJECT level custom field#2 that would re-use all
TASK custom field#1 values to compute an overall project schedule status.
1) Is-it possible to use TASK custom field#1 within PROJECT custom field#2
formular?
2) If so, how to write a formular that would compute the following:
if all project's TASK custom field#1 values are "on time" then value = "on
time"
if all project's TASK custom field#1 values are "done" then value = "done"
if one project's TASK custom field#1 value is "late" then value = "late"

thanks for your help
jpa

 

[Dale Howard [MVP]]

jpa --

You will need to create the formula for the Project custom field, and
manually input the formula and the graphical indicators. You cannot
reference the Task custom field in your formula. You ARE using a formula
for this, right? If so, what is your formula? Let us know and we will try
to help you.

 

[jpa]

Thanks for your quick reply
The formular I use for Task Custom Field is the following:

IIf([% Work Complete]=100,"Done",IIf(ProjDateValue([Baseline
Finish])=4294967295,"No Baseline",IIf(DateDiff("d",[Baseline
Finish],[Finish])>=10,"Late 10d+",IIf(DateDiff("d",[Baseline
Finish],[Finish])>=1 And DateDiff("d",[Baseline Finish],[Finish])<10,"Late
1~10d",IIf(DateDiff("d",Date(),[Baseline Start])>0,"Not Started","On
time")))))

How to reflect any task delay at project level (even if Project Baseline
Finish is not overdue)?
Thanks in advance
jpa

 

[Dale Howard [MVP]]

jpa --

I don't think your original formula makes a lot of sense at the project
level. A cleaner way to handle this would be to use the following formula
in a custom enterprise project Task field:

IIf([Baseline Finish]=ProjDateValue("NA"),"No Baseline",IIf(([Finish
Variance]/480)>=10,"Late 10d+",IIf(([Finish Variance]/480)>=1,"Late
1~10d","On time")))

This way you can easily see if the project is terribly late, late, or on
schedule. Hope this helps.

Thanks for your quick reply
The formular I use for Task Custom Field is the following:

IIf([% Work Complete]=100,"Done",IIf(ProjDateValue([Baseline
Finish])=4294967295,"No Baseline",IIf(DateDiff("d",[Baseline
Finish],[Finish])>=10,"Late 10d+",IIf(DateDiff("d",[Baseline
Finish],[Finish])>=1 And DateDiff("d",[Baseline Finish],[Finish])<10,"Late
1~10d",IIf(DateDiff("d",Date(),[Baseline Start])>0,"Not Started","On
time")))))

How to reflect any task delay at project level (even if Project Baseline
Finish is not overdue)?
Thanks in advance
jpa

jpa --

You will need to create the formula for the Project custom field, and
manually input the formula and the graphical indicators. You cannot
reference the Task custom field in your formula. You ARE using a formula
for this, right? If so, what is your formula? Let us know and we will
try
to help you.