Formula issues

[Sameer]

If a Project Manager does not save a baseline, then the baseline start or the
baseline finish is "NA". Now i am trying to use a formula whihc says:

If basline start="NA" show me a white indicator

This does not seem to work. Is there any other way i can tell my executives
whether the baseline is saved or not by using a formula or an indicator?????

Thnx in advance.

 

[Guest]

Give this a try...

IIf([Baseline Start]>999999,"No Baseline")

Bob Segrest, PMP

 

[Dale Howard [MVP]]

Sameer --

You can use the IIf(ProjDateValue([Baseline Start])="NA", true expression,
false expression) expression to test for an NA condition in the Baseline
Start field. Hope this helps.