Problem with a formula (does not have dates in it)

[erica.standrich]

hi,

I think what I'm trying to do is relatively simple, but I can't figure
out how to make it work.

Basically, I need this : I need a field to populate either "Yes" or
"No" depending on another field.

So, Field A = "yes" if Field B has a value, Field A = "no" if Field B
does not have a value.

I have this defined for Field A:

IIf(([WorkPackageIDSequence]<>IsNull
([WorkPackageIDSequence])),"Yes","No")

where WorkPackageIDSequence is the theoretical Field B.

What I'm getting is "Yes" for everything, regardless if there's a
value in WorkPackageIDSequence or not.

Please help!

 

[Gérard Ducouret]

Hello,

What is the type of field B ? Text? Date? Number?
Is it completely empty or does it displays 'NA'?

Gérard Ducouret

 

[Gérard Ducouret]

If field B is a date type field, the formula could be:

IIf([Field B]=ProjDateValue('NA'),False,True)

Hope this helps,

Gérard Ducouret

Hello,

What is the type of field B ? Text? Date? Number?
Is it completely empty or does it displays 'NA'?

Gérard Ducouret

hi,

I think what I'm trying to do is relatively simple, but I can't figure
out how to make it work.

Basically, I need this : I need a field to populate either "Yes" or
"No" depending on another field.

So, Field A = "yes" if Field B has a value, Field A = "no" if Field B
does not have a value.

I have this defined for Field A:

IIf(([WorkPackageIDSequence]<>IsNull
([WorkPackageIDSequence])),"Yes","No")

where WorkPackageIDSequence is the theoretical Field B.

What I'm getting is "Yes" for everything, regardless if there's a
value in WorkPackageIDSequence or not.

Please help!

 

[Erica]

Hello,

What is the type of field B ? Text?  Date? Number?
Is it completely empty or does it displays 'NA'?

Gérard Ducouret

Hi Gérard,

Field B is a Task Level Text type field. It's completely empty when
there's no value typed into it - there is no 'NA' that shows up in the
field. Just a blank cell.

Thanks,
Erica

 

[Erica]

Thanks for the suggestion, but unfortunately it's not a date field...
I keep seeing examples of formulas with date fields, but not what I
need.

Thanks, though!

Erica

 

[Erica]

I figured it out... I had to change the type of Field A to be a "flag"
instead of "text" and then used this formula:

[WorkPackageIDSequence]<>""

It returns "Yes" when there is a value in WorkPackageIDSequence and
"No" when there is not a value.

Hope this helps someone in the future.

Erica

 

[Mike Glen]

Thanks for the feedback, Erica, that sounds like a useful function

Mike Glen
Project MVP
See http://tinyurl.com/2xbhc for my free Project Tutorials