How do I check using Project Pro if a task has beeen baselined?

G

Gene

I think I posted this to the wrong group earlier. I should have posted
it here for Project Developers.

We are using Project Server 2003 and have a number of Enterprise Task
Text fields that display some indicator to show if the task is on-time,

etc. The problem is when using Project Pro 2003 we have not found a
calculation that recognizes if a task has been baselined. The
Enterprise Task Text filed displays #ERROR if the calculated field
tries to use a non-baselined field in a calculation. Can someone give
me a formula to identified that a baseline field has not been populated

(i.e. Baseline Start has not been populated)?

Here is a formula we tried, but the Len(CStr([Baseline Finish]))<3,"No
baseline" doesn't work.
Switch([Status]=0,"Completed",[Status]=3,"Future",Len(CStr([Baseline
Finish]))<3,"No baseline",ProjDateDiff([Baseline
Finish],[Finish])/480>=5,"Late by more than 5
days",ProjDateDiff([Baseline Finish],[Finish])/480>0,"Late",True,"On
schedule")
 
G

Gérard Ducouret

Hello Gene,
Try something like that :
IIf([Baselin Start]=ProjDateValue('NC');"No Baseline";"Yes")

Gérard Ducouret
 
G

Gérard Ducouret

Another one :
IIf([Baseline Start]=(2^32)-1;"No Baseline";"Yes")

Gérard Ducouret

Gérard Ducouret said:
Hello Gene,
Try something like that :
IIf([Baselin Start]=ProjDateValue('NC');"No Baseline";"Yes")

Gérard Ducouret

Gene said:
I think I posted this to the wrong group earlier. I should have posted
it here for Project Developers.

We are using Project Server 2003 and have a number of Enterprise Task
Text fields that display some indicator to show if the task is on-time,

etc. The problem is when using Project Pro 2003 we have not found a
calculation that recognizes if a task has been baselined. The
Enterprise Task Text filed displays #ERROR if the calculated field
tries to use a non-baselined field in a calculation. Can someone give
me a formula to identified that a baseline field has not been populated

(i.e. Baseline Start has not been populated)?

Here is a formula we tried, but the Len(CStr([Baseline Finish]))<3,"No
baseline" doesn't work.
Switch([Status]=0,"Completed",[Status]=3,"Future",Len(CStr([Baseline
Finish]))<3,"No baseline",ProjDateDiff([Baseline
Finish],[Finish])/480>=5,"Late by more than 5
days",ProjDateDiff([Baseline Finish],[Finish])/480>0,"Late",True,"On
schedule")
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top