custom field formula question

[Kris R.]

How does one prevent a #ERROR from appearing in a cell, with a formula like
this:

Iif ([Finish] > [Deadline],1,0)

in the cases where a deadline has not been defined for a task?(ie, it is
"NA")

I can't seem to trap the condition when a field is not defined.

IsDate([Deadline]) returns a true, because it's a date field, even if a date
hasn't been defined.

You can't do Iif ([Deadline] = "NA",1,0) because you can't compare a date to
a string.

You can't convert deadline to a string (Str() or Cstr())

I've tried everything I can think of!

How in the heck do you do this??

Thanks,
Kris R.

 

[vicky]

may if([Deadline] = "",1,0) be useful?

 

[JulieS]

Hi Kris R.
See Jack Dahlgren's site:
http://masamiki.com/project/customfieldFAQ.htm

Hope this helps. Let us know how you get along.
Julie

 

[Kris R.]

BRILLIANT!

Just what I needed to know!!

Thanks so much,
Kris R.

Hi Kris R.
See Jack Dahlgren's site:
http://masamiki.com/project/customfieldFAQ.htm

Hope this helps. Let us know how you get along.
Julie

How does one prevent a #ERROR from appearing in a cell, with a formula
like
this:

Iif ([Finish] > [Deadline],1,0)

in the cases where a deadline has not been defined for a task?(ie, it is
"NA")

I can't seem to trap the condition when a field is not defined.

IsDate([Deadline]) returns a true, because it's a date field, even if a
date
hasn't been defined.

You can't do Iif ([Deadline] = "NA",1,0) because you can't compare a date
to
a string.

You can't convert deadline to a string (Str() or Cstr())

I've tried everything I can think of!

How in the heck do you do this??

Thanks,
Kris R.

 

[JackD]

Brian K. has an alternate method that works and is a bit less confusing:

[Baseline Finish]=ProjDateValue("NA")

I've been meaning to add it to my site.
--
-Jack ... For project information and macro examples visit
http://masamiki.com/project

..

Hi Kris R.
See Jack Dahlgren's site:
http://masamiki.com/project/customfieldFAQ.htm

Hope this helps. Let us know how you get along.
Julie

How does one prevent a #ERROR from appearing in a cell, with a formula like
this:

Iif ([Finish] > [Deadline],1,0)

in the cases where a deadline has not been defined for a task?(ie, it is
"NA")

I can't seem to trap the condition when a field is not defined.

IsDate([Deadline]) returns a true, because it's a date field, even if a date
hasn't been defined.

You can't do Iif ([Deadline] = "NA",1,0) because you can't compare a date to
a string.

You can't convert deadline to a string (Str() or Cstr())

I've tried everything I can think of!

How in the heck do you do this??

Thanks,
Kris R.

 

[Kris R.]

Oh, that is EVEN slicker!! That makes more sense, too, that the
ProjDateValue function could handle "NA". That must have been the ONLY
function I DIDN'T try! ;-)

Thanks!
Kris

Brian K. has an alternate method that works and is a bit less confusing:

[Baseline Finish]=ProjDateValue("NA")

I've been meaning to add it to my site.
--
-Jack ... For project information and macro examples visit
http://masamiki.com/project

.

Hi Kris R.
See Jack Dahlgren's site:
http://masamiki.com/project/customfieldFAQ.htm

Hope this helps. Let us know how you get along.
Julie

How does one prevent a #ERROR from appearing in a cell, with a formula like
this:

Iif ([Finish] > [Deadline],1,0)

in the cases where a deadline has not been defined for a task?(ie, it
is
"NA")

I can't seem to trap the condition when a field is not defined.

IsDate([Deadline]) returns a true, because it's a date field, even if a date
hasn't been defined.

You can't do Iif ([Deadline] = "NA",1,0) because you can't compare a date to
a string.

You can't convert deadline to a string (Str() or Cstr())

I've tried everything I can think of!

How in the heck do you do this??

Thanks,
Kris R.