Customize Fields

[Reut]

Hi,

I am trying to build a flag that indicates if the PM saved Baseline.
The condition i wrote is : iif([Baseline start],true,false) but it's not
working!!
I also tried to to use a number field with (0,1) result- but it didnt work
again!

Thanks, Reut.

 

[John]

Hi,

I am trying to build a flag that indicates if the PM saved Baseline.
The condition i wrote is : iif([Baseline start],true,false) but it's not
working!!
I also tried to to use a number field with (0,1) result- but it didnt work
again!

Thanks, Reut.

Reut,
The reason your formula didn't do what you wanted is because even an NA
in the Baseline Start field is a value from Project's perspective. So
you need to test for it. Try the following formula:
IIf([Baseline Start]<50000,True,False)

Hope this helps.
John
Project MVP

 

[Jim Aksel]

The Baseline Start field is of type "Date" not "Boolean." Looking at any
task without a baseline set you will see the value "NA", try changing your
iif statement to something like this:
iif([Baseline Start]="NA","No","Yes") will return "Yes" in the flag field
if Baseline Start does not equal "NA" ....

Alternatively:
iff([Baseline Start]<>"NA","Yes","No")

I prefer the positive logic .... if it equals "NA" you know a baseline has
not been set. Although project will not allow anything other than a date in
that column, testing on not "NA" does not guarantee the existence or truth
of something. Example, testing on [Political Affiliation] <> "Replublican"
does not guarantee we know the political affiliation value, it could be
anything other than "Republican" and there is more than one choice in the US.

 

[Jim Aksel]

Sorry, it's too early for me out here... my formula returns an error. It
looks like John also posted. My formula requires a little more finense to
convert the date to a string value, but John's works just fine.

The Baseline Start field is of type "Date" not "Boolean." Looking at any
task without a baseline set you will see the value "NA", try changing your
iif statement to something like this:
iif([Baseline Start]="NA","No","Yes") will return "Yes" in the flag field
if Baseline Start does not equal "NA" ....

Alternatively:
iff([Baseline Start]<>"NA","Yes","No")

I prefer the positive logic .... if it equals "NA" you know a baseline has
not been set. Although project will not allow anything other than a date in
that column, testing on not "NA" does not guarantee the existence or truth
of something. Example, testing on [Political Affiliation] <> "Replublican"
does not guarantee we know the political affiliation value, it could be
anything other than "Republican" and there is more than one choice in the US.

Hi,

I am trying to build a flag that indicates if the PM saved Baseline.
The condition i wrote is : iif([Baseline start],true,false) but it's not
working!!
I also tried to to use a number field with (0,1) result- but it didnt work
again!

Thanks, Reut.

 

[JulieS]

Hi Reut,

In addition to John's suggestion, please see fellow MVP Jack Dahlgren's blog
entry about testing for "NA" at:

http://zo-d.com/blog/archives/programming/working-with-custom-field-formulas.html

I hope this helps. Let us know how you get along.

Julie

 

[Dale Howard [MVP]]

Reut --

Since a number of folks have offered potential answers to your question,
here's one more for you to ponder. Create the formula like this:

IIf([Baseline Start]<>ProjDateValue("NA"),True,False)

The ProjDateValue function is a direct way to test for the "NA" value in any
date field. Hope this helps.

 

[Reut]

Thanks! It really helps..

Reut --

Since a number of folks have offered potential answers to your question,
here's one more for you to ponder. Create the formula like this:

IIf([Baseline Start]<>ProjDateValue("NA"),True,False)

The ProjDateValue function is a direct way to test for the "NA" value in any
date field. Hope this helps.

Hi,

I am trying to build a flag that indicates if the PM saved Baseline.
The condition i wrote is : iif([Baseline start],true,false) but it's not
working!!
I also tried to to use a number field with (0,1) result- but it didnt work
again!

Thanks, Reut.

 

[Dale Howard [MVP]]

Reut --

You are more than welcome, my friend!

Thanks! It really helps..

Reut --

Since a number of folks have offered potential answers to your question,
here's one more for you to ponder. Create the formula like this:

IIf([Baseline Start]<>ProjDateValue("NA"),True,False)

The ProjDateValue function is a direct way to test for the "NA" value in
any
date field. Hope this helps.

Hi,

I am trying to build a flag that indicates if the PM saved Baseline.
The condition i wrote is : iif([Baseline start],true,false) but it's
not
working!!
I also tried to to use a number field with (0,1) result- but it didnt
work
again!

Thanks, Reut.