Custom field formula #error

[sylva]

I am trying to create a flag to display 10d in advance of a deadline in MS
project 2000 I can get the flag to work by entering formula deadline -10 but
as some of the fields are blank they display #error I have tried every
formula I can think of to cure this I would welcome any examples of a
formulas to do this.

 

[Gérard Ducouret]

Sylva,
Look at the IIF condition in this formula :

IIf([Baseline Finish]=ProjDateValue('NA');"No
Baseline";IIf(ProjDateDiff([Baseline Finish];[Finish])/480>=5;"Late by more
than 5 days";IIf(ProjDateDiff([Baseline Finish];[Finish])/480>0;"late";"On
schedule")))

Hope this helps

Gérard Ducouret

 

[John]

I am trying to create a flag to display 10d in advance of a deadline in MS
project 2000 I can get the flag to work by entering formula deadline -10 but
as some of the fields are blank they display #error I have tried every
formula I can think of to cure this I would welcome any examples of a
formulas to do this.

Sylva,
You didn't specify if you are using the Deadline field for your deadline
data but try this formula:
IIf(isdate([Deadline]-10),"yes","no")

Hope this helps.
John
Project MVP

 

[sylva]

John many thanks for your help I have tried your formula and it works but it
gives me a yes / no field
what I am trying to get is a custom date or finish field diplaying a date
value 10 days prior to the deadline date I can get the value formula to work
by finish 2=
deadline -10
this gives me the requirded date but where the field is NA I get an #error
what i would like to do is get this to display NA as it does in the deadline
field I am then using traffic light indicators green ,amber , red, to look at
finish dates
green scheduled finish before 10 proir to deadline
amber scheduled finish between 1 &10 prior to deadline
red scheduled finish after deadline date
do you know what I can add to the finish field 2 formula to correct this I
am sure it is because the program is looking for a date and does not
recognise the NA
--
sylva

I am trying to create a flag to display 10d in advance of a deadline in MS
project 2000 I can get the flag to work by entering formula deadline -10 but
as some of the fields are blank they display #error I have tried every
formula I can think of to cure this I would welcome any examples of a
formulas to do this.

Sylva,
You didn't specify if you are using the Deadline field for your deadline
data but try this formula:
IIf(isdate([Deadline]-10),"yes","no")

Hope this helps.
John
Project MVP

 

[John]

John many thanks for your help I have tried your formula and it works but it
gives me a yes / no field
what I am trying to get is a custom date or finish field diplaying a date
value 10 days prior to the deadline date I can get the value formula to work
by finish 2=
deadline -10
this gives me the requirded date but where the field is NA I get an #error
what i would like to do is get this to display NA as it does in the deadline
field I am then using traffic light indicators green ,amber , red, to look at
finish dates
green scheduled finish before 10 proir to deadline
amber scheduled finish between 1 &10 prior to deadline
red scheduled finish after deadline date
do you know what I can add to the finish field 2 formula to correct this I
am sure it is because the program is looking for a date and does not
recognise the NA

sylva,
First of all, I hate formulas. Project is sorely lacking in syntax
information and the help file is pathetic when there is a problem.

Now that that's off my chest (until next time), try this formula:
Finish2=IIf(isdate([Deadline]-10),[Deadline]-10,"NA")

Hope this helps.
John
Project MVP

 

[sylva]

thanks John this is just what i needed
sylva

John many thanks for your help I have tried your formula and it works but it
gives me a yes / no field
what I am trying to get is a custom date or finish field diplaying a date
value 10 days prior to the deadline date I can get the value formula to work
by finish 2=
deadline -10
this gives me the requirded date but where the field is NA I get an #error
what i would like to do is get this to display NA as it does in the deadline
field I am then using traffic light indicators green ,amber , red, to look at
finish dates
green scheduled finish before 10 proir to deadline
amber scheduled finish between 1 &10 prior to deadline
red scheduled finish after deadline date
do you know what I can add to the finish field 2 formula to correct this I
am sure it is because the program is looking for a date and does not
recognise the NA

sylva,
First of all, I hate formulas. Project is sorely lacking in syntax
information and the help file is pathetic when there is a problem.

Now that that's off my chest (until next time), try this formula:
Finish2=IIf(isdate([Deadline]-10),[Deadline]-10,"NA")

Hope this helps.
John
Project MVP

 

[John]

thanks John this is just what i needed
sylva

John many thanks for your help I have tried your formula and it works but
it
gives me a yes / no field
what I am trying to get is a custom date or finish field diplaying a date
value 10 days prior to the deadline date I can get the value formula to
work
by finish 2=
deadline -10
this gives me the requirded date but where the field is NA I get an
#error
what i would like to do is get this to display NA as it does in the
deadline
field I am then using traffic light indicators green ,amber , red, to
look at
finish dates
green scheduled finish before 10 proir to deadline
amber scheduled finish between 1 &10 prior to deadline
red scheduled finish after deadline date
do you know what I can add to the finish field 2 formula to correct this
I
am sure it is because the program is looking for a date and does not
recognise the NA

sylva,
First of all, I hate formulas. Project is sorely lacking in syntax
information and the help file is pathetic when there is a problem.

Now that that's off my chest (until next time), try this formula:
Finish2=IIf(isdate([Deadline]-10),[Deadline]-10,"NA")

Hope this helps.
John
Project MVP

sylva,
Your're welcome

John