"NA" in enterprise field formulas?

[Jesse]

I'm trying to setup some custom fields (text type for task field)
interrogating fields to see if they have a value or not. One such field,
[actual start] field will display NA in the gantt if the task hasn't started.
I have the formula IIF[actual start]="NA",1,2]. I setup grapical indicators
for 1 = yellow ball and 2 = green ball. In the gantt if [actual start]=NA I
don't get an indicator...while if [actual start] does have a value then I do
get a green ball. I've tried using NA in a Switch formula also but cannot
get it to work. Does the NA work in an enterprise field formula or should I
be using something else?

 

[Dale Howard [MVP]]

Jesse --

Write your formula this way:

IIf([Actual Start]=ProjDateValue("NA"),1,2)

This is the easiest way to test for the "NA" value a date field. Hope this
helps.

 

[Jesse]

Thanks Dale! worked like a charm. I'm playing with some task status type
inticators (late to start, started late, late to finish, finished late, etc.)

Switch([Actual Finish]<>ProjDateValue("NA"),"finished",([Actual
Start]<>ProjDateValue("NA") And [Actual Start]>[Baseline Start]),"started
late",([Actual Start]=ProjDateValue("NA") And [Current Date]>[Start]),"late
to start",[Actual Start]=ProjDateValue("NA"),"not started",[Actual
Start]<>ProjDateValue("NA"),"started")

Thanks for the help
--
Jesse

Jesse --

Write your formula this way:

IIf([Actual Start]=ProjDateValue("NA"),1,2)

This is the easiest way to test for the "NA" value a date field. Hope this
helps.

I'm trying to setup some custom fields (text type for task field)
interrogating fields to see if they have a value or not. One such field,
[actual start] field will display NA in the gantt if the task hasn't
started.
I have the formula IIF[actual start]="NA",1,2]. I setup grapical
indicators
for 1 = yellow ball and 2 = green ball. In the gantt if [actual start]=NA
I
don't get an indicator...while if [actual start] does have a value then I
do
get a green ball. I've tried using NA in a Switch formula also but cannot
get it to work. Does the NA work in an enterprise field formula or should
I
be using something else?

 

[JackD]

In cases like this I'd use % complete rather than looking for actual
start/actual finish. It would sidestep the whole "NA" thing.
But if this works for you stick with it.

-Jack Dahlgren

Thanks Dale! worked like a charm. I'm playing with some task status type
inticators (late to start, started late, late to finish, finished late,
etc.)

Switch([Actual Finish]<>ProjDateValue("NA"),"finished",([Actual
Start]<>ProjDateValue("NA") And [Actual Start]>[Baseline Start]),"started
late",([Actual Start]=ProjDateValue("NA") And [Current
Date]>[Start]),"late
to start",[Actual Start]=ProjDateValue("NA"),"not started",[Actual
Start]<>ProjDateValue("NA"),"started")

Thanks for the help
--
Jesse

Jesse --

Write your formula this way:

IIf([Actual Start]=ProjDateValue("NA"),1,2)

This is the easiest way to test for the "NA" value a date field. Hope
this
helps.

I'm trying to setup some custom fields (text type for task field)
interrogating fields to see if they have a value or not. One such
field,
[actual start] field will display NA in the gantt if the task hasn't
started.
I have the formula IIF[actual start]="NA",1,2]. I setup grapical
indicators
for 1 = yellow ball and 2 = green ball. In the gantt if [actual
start]=NA
I
don't get an indicator...while if [actual start] does have a value then
I
do
get a green ball. I've tried using NA in a Switch formula also but
cannot
get it to work. Does the NA work in an enterprise field formula or
should
I
be using something else?

 

[Jesse]

Thanks for the tip Jack...I like it!
--
Jesse

In cases like this I'd use % complete rather than looking for actual
start/actual finish. It would sidestep the whole "NA" thing.
But if this works for you stick with it.

-Jack Dahlgren

Thanks Dale! worked like a charm. I'm playing with some task status type
inticators (late to start, started late, late to finish, finished late,
etc.)

Switch([Actual Finish]<>ProjDateValue("NA"),"finished",([Actual
Start]<>ProjDateValue("NA") And [Actual Start]>[Baseline Start]),"started
late",([Actual Start]=ProjDateValue("NA") And [Current
Date]>[Start]),"late
to start",[Actual Start]=ProjDateValue("NA"),"not started",[Actual
Start]<>ProjDateValue("NA"),"started")

Thanks for the help
--
Jesse

Jesse --

Write your formula this way:

IIf([Actual Start]=ProjDateValue("NA"),1,2)

This is the easiest way to test for the "NA" value a date field. Hope
this
helps.




I'm trying to setup some custom fields (text type for task field)
interrogating fields to see if they have a value or not. One such
field,
[actual start] field will display NA in the gantt if the task hasn't
started.
I have the formula IIF[actual start]="NA",1,2]. I setup grapical
indicators
for 1 = yellow ball and 2 = green ball. In the gantt if [actual
start]=NA
I
don't get an indicator...while if [actual start] does have a value then
I
do
get a green ball. I've tried using NA in a Switch formula also but
cannot
get it to work. Does the NA work in an enterprise field formula or
should
I
be using something else?