Customized Field Formula

[KLA]

I am attempting to customize the finish 1 field. I want the value to be
calculated based on the Actual Start date + 40 days duration (which I have
used duration 1, populated with 40d) based on my project calendar. This
formula works and gives the value that I expected however if the Actual Start
date has not yet been populated (tasks that have not yet started) and the
current value is NA I am receiving an error message in the customized finish
1 field. How can I modify my formula to ignore the "NA"'s in the Actual
start column? The following is the current formula:

ProjDateAdd([Actual Start],[Duration1],[Project Calendar])

 

[Dale Howard [MVP]]

KLA --

To "trap" for an NA value in a Date field, you need to use the following
Function:

IIF([Actual Start] = ProjDateValue("NA), truepart, falsepart)

So, rewrite your original formula using the above. Hope this helps.

 

[KLA]

The following is the revised formula that I tried for the customized field:

IIF(([Actual Start] = ProjDateValue("NA), (“NAâ€), ProjDateAdd([Actual
Start],[Duration1],[Project Calendar]))

Which results in the following error: "The formula contains a syntax error
or contains a reference to an unrecognized field or function name. To return
to the Formula dialog box and highlight the error, click OK".

The following is highlighted when I return to the formula dialog box:

"NA), (“NAâ€), ProjDateAdd([Actual Start],[Duration1],[Project Calendar]))

Is "NA" considered to be "null" in project? Is there a formula for if ACT
ST is null populate finish 1 with NA?

KLA --

To "trap" for an NA value in a Date field, you need to use the following
Function:

IIF([Actual Start] = ProjDateValue("NA), truepart, falsepart)

So, rewrite your original formula using the above. Hope this helps.

I am attempting to customize the finish 1 field. I want the value to be
calculated based on the Actual Start date + 40 days duration (which I have
used duration 1, populated with 40d) based on my project calendar. This
formula works and gives the value that I expected however if the Actual
Start
date has not yet been populated (tasks that have not yet started) and the
current value is NA I am receiving an error message in the customized
finish
1 field. How can I modify my formula to ignore the "NA"'s in the Actual
start column? The following is the current formula:

ProjDateAdd([Actual Start],[Duration1],[Project Calendar])

 

[Dave]

There is a minor typo in the formula provided by Dale.

In order to convert NA into a date value, you need to use the function
ProjDateValue():

ProjDateValue( "NA" ) note the second speech mark.

You will also have to convert your ("NA") to a value of type date in the
same way.

The following is the revised formula that I tried for the customized field:

IIF(([Actual Start] = ProjDateValue("NA), (“NAâ€), ProjDateAdd([Actual
Start],[Duration1],[Project Calendar]))

Which results in the following error: "The formula contains a syntax error
or contains a reference to an unrecognized field or function name. To return
to the Formula dialog box and highlight the error, click OK".

The following is highlighted when I return to the formula dialog box:

"NA), (“NAâ€), ProjDateAdd([Actual Start],[Duration1],[Project Calendar]))

Is "NA" considered to be "null" in project? Is there a formula for if ACT
ST is null populate finish 1 with NA?

KLA --

To "trap" for an NA value in a Date field, you need to use the following
Function:

IIF([Actual Start] = ProjDateValue("NA), truepart, falsepart)

So, rewrite your original formula using the above. Hope this helps.

I am attempting to customize the finish 1 field. I want the value to be
calculated based on the Actual Start date + 40 days duration (which I have
used duration 1, populated with 40d) based on my project calendar. This
formula works and gives the value that I expected however if the Actual
Start
date has not yet been populated (tasks that have not yet started) and the
current value is NA I am receiving an error message in the customized
finish
1 field. How can I modify my formula to ignore the "NA"'s in the Actual
start column? The following is the current formula:

ProjDateAdd([Actual Start],[Duration1],[Project Calendar])

 

[KLA]

Dave, I apologize but I am not accustomed to writing formulas and this is my
first attempt in MS Project. I've tried both entries and get the same syntax
error. Below is the formula that I entered that received the error:

IIF(([Actual Start] = ProjDateValue("NA"), ProjDateValue("NA"),
ProjDateAdd([Actual Start],[Duration1],[Project Calendar]))

The second ProjDateValue("NA") represents the truepart, the
ProjDateAdd...represents the falsepart. I can't figure out what I am doing
wrong. I just want the NA to remain an NA if that's what is shown in the
Actual Start field.

There is a minor typo in the formula provided by Dale.

In order to convert NA into a date value, you need to use the function
ProjDateValue():

ProjDateValue( "NA" ) note the second speech mark.

You will also have to convert your ("NA") to a value of type date in the
same way.

The following is the revised formula that I tried for the customized field:

IIF(([Actual Start] = ProjDateValue("NA), (“NAâ€), ProjDateAdd([Actual
Start],[Duration1],[Project Calendar]))

Which results in the following error: "The formula contains a syntax error
or contains a reference to an unrecognized field or function name. To return
to the Formula dialog box and highlight the error, click OK".

The following is highlighted when I return to the formula dialog box:

"NA), (“NAâ€), ProjDateAdd([Actual Start],[Duration1],[Project Calendar]))

Is "NA" considered to be "null" in project? Is there a formula for if ACT
ST is null populate finish 1 with NA?

KLA --

To "trap" for an NA value in a Date field, you need to use the following
Function:

IIF([Actual Start] = ProjDateValue("NA), truepart, falsepart)

So, rewrite your original formula using the above. Hope this helps.




I am attempting to customize the finish 1 field. I want the value to be
calculated based on the Actual Start date + 40 days duration (which I have
used duration 1, populated with 40d) based on my project calendar. This
formula works and gives the value that I expected however if the Actual
Start
date has not yet been populated (tasks that have not yet started) and the
current value is NA I am receiving an error message in the customized
finish
1 field. How can I modify my formula to ignore the "NA"'s in the Actual
start column? The following is the current formula:

ProjDateAdd([Actual Start],[Duration1],[Project Calendar])

 

[Dale Howard [MVP]]

KLA --

Sorry for the typo in the first reply. Try this formula, as it should work
for you now:

IIf([Actual Start]=ProjDateValue("NA"),"NA",ProjDateAdd([Actual
Start],[Duration1],[Project Calendar]))

Hope this helps.

Dave, I apologize but I am not accustomed to writing formulas and this is
my
first attempt in MS Project. I've tried both entries and get the same
syntax
error. Below is the formula that I entered that received the error:

IIF(([Actual Start] = ProjDateValue("NA"), ProjDateValue("NA"),
ProjDateAdd([Actual Start],[Duration1],[Project Calendar]))

The second ProjDateValue("NA") represents the truepart, the
ProjDateAdd...represents the falsepart. I can't figure out what I am
doing
wrong. I just want the NA to remain an NA if that's what is shown in the
Actual Start field.

There is a minor typo in the formula provided by Dale.

In order to convert NA into a date value, you need to use the function
ProjDateValue():

ProjDateValue( "NA" ) note the second speech mark.

You will also have to convert your ("NA") to a value of type date in the
same way.

The following is the revised formula that I tried for the customized
field:

IIF(([Actual Start] = ProjDateValue("NA), (“NAâ€), ProjDateAdd([Actual
Start],[Duration1],[Project Calendar]))

Which results in the following error: "The formula contains a syntax
error
or contains a reference to an unrecognized field or function name. To
return
to the Formula dialog box and highlight the error, click OK".

The following is highlighted when I return to the formula dialog box:

"NA), (“NAâ€), ProjDateAdd([Actual Start],[Duration1],[Project
Calendar]))

Is "NA" considered to be "null" in project? Is there a formula for if
ACT
ST is null populate finish 1 with NA?

:

KLA --

To "trap" for an NA value in a Date field, you need to use the
following
Function:

IIF([Actual Start] = ProjDateValue("NA), truepart, falsepart)

So, rewrite your original formula using the above. Hope this helps.




I am attempting to customize the finish 1 field. I want the value to
be
calculated based on the Actual Start date + 40 days duration (which I
have
used duration 1, populated with 40d) based on my project calendar.
This
formula works and gives the value that I expected however if the
Actual
Start
date has not yet been populated (tasks that have not yet started) and
the
current value is NA I am receiving an error message in the customized
finish
1 field. How can I modify my formula to ignore the "NA"'s in the
Actual
start column? The following is the current formula:

ProjDateAdd([Actual Start],[Duration1],[Project Calendar])

 

[KLA]

Dale - You are the Best! There was an extra space between Actual Start but
when it was deleted the formula works! Thank you! The following is the
corrected formula that works:

IIf([Actual Start]=ProjDateValue("NA"),"NA",ProjDateAdd([Actual
Start],[Duration1],[Project Calendar]))

Again a million thanks!
KLA

KLA --

Sorry for the typo in the first reply. Try this formula, as it should work
for you now:

IIf([Actual Start]=ProjDateValue("NA"),"NA",ProjDateAdd([Actual
Start],[Duration1],[Project Calendar]))

Hope this helps.

Dave, I apologize but I am not accustomed to writing formulas and this is
my
first attempt in MS Project. I've tried both entries and get the same
syntax
error. Below is the formula that I entered that received the error:

IIF(([Actual Start] = ProjDateValue("NA"), ProjDateValue("NA"),
ProjDateAdd([Actual Start],[Duration1],[Project Calendar]))

The second ProjDateValue("NA") represents the truepart, the
ProjDateAdd...represents the falsepart. I can't figure out what I am
doing
wrong. I just want the NA to remain an NA if that's what is shown in the
Actual Start field.

There is a minor typo in the formula provided by Dale.

In order to convert NA into a date value, you need to use the function
ProjDateValue():

ProjDateValue( "NA" ) note the second speech mark.

You will also have to convert your ("NA") to a value of type date in the
same way.



KLA wrote:
The following is the revised formula that I tried for the customized
field:

IIF(([Actual Start] = ProjDateValue("NA), (“NAâ€), ProjDateAdd([Actual
Start],[Duration1],[Project Calendar]))

Which results in the following error: "The formula contains a syntax
error
or contains a reference to an unrecognized field or function name. To
return
to the Formula dialog box and highlight the error, click OK".

The following is highlighted when I return to the formula dialog box:

"NA), (“NAâ€), ProjDateAdd([Actual Start],[Duration1],[Project
Calendar]))

Is "NA" considered to be "null" in project? Is there a formula for if
ACT
ST is null populate finish 1 with NA?

:

KLA --

To "trap" for an NA value in a Date field, you need to use the
following
Function:

IIF([Actual Start] = ProjDateValue("NA), truepart, falsepart)

So, rewrite your original formula using the above. Hope this helps.




I am attempting to customize the finish 1 field. I want the value to
be
calculated based on the Actual Start date + 40 days duration (which I
have
used duration 1, populated with 40d) based on my project calendar.
This
formula works and gives the value that I expected however if the
Actual
Start
date has not yet been populated (tasks that have not yet started) and
the
current value is NA I am receiving an error message in the customized
finish
1 field. How can I modify my formula to ignore the "NA"'s in the
Actual
start column? The following is the current formula:

ProjDateAdd([Actual Start],[Duration1],[Project Calendar])

 

[Dale Howard [MVP]]

KLA --

You are more than welcome, my friend!

Dale - You are the Best! There was an extra space between Actual Start
but
when it was deleted the formula works! Thank you! The following is the
corrected formula that works:

IIf([Actual Start]=ProjDateValue("NA"),"NA",ProjDateAdd([Actual
Start],[Duration1],[Project Calendar]))

Again a million thanks!
KLA

KLA --

Sorry for the typo in the first reply. Try this formula, as it should
work
for you now:

IIf([Actual Start]=ProjDateValue("NA"),"NA",ProjDateAdd([Actual
Start],[Duration1],[Project Calendar]))

Hope this helps.

Dave, I apologize but I am not accustomed to writing formulas and this
is
my
first attempt in MS Project. I've tried both entries and get the same
syntax
error. Below is the formula that I entered that received the error:

IIF(([Actual Start] = ProjDateValue("NA"), ProjDateValue("NA"),
ProjDateAdd([Actual Start],[Duration1],[Project Calendar]))

The second ProjDateValue("NA") represents the truepart, the
ProjDateAdd...represents the falsepart. I can't figure out what I am
doing
wrong. I just want the NA to remain an NA if that's what is shown in
the
Actual Start field.

:

There is a minor typo in the formula provided by Dale.

In order to convert NA into a date value, you need to use the function
ProjDateValue():

ProjDateValue( "NA" ) note the second speech mark.

You will also have to convert your ("NA") to a value of type date in
the
same way.



KLA wrote:
The following is the revised formula that I tried for the customized
field:

IIF(([Actual Start] = ProjDateValue("NA), (“NAâ€),
ProjDateAdd([Actual
Start],[Duration1],[Project Calendar]))

Which results in the following error: "The formula contains a syntax
error
or contains a reference to an unrecognized field or function name.
To
return
to the Formula dialog box and highlight the error, click OK".

The following is highlighted when I return to the formula dialog
box:

"NA), (“NAâ€), ProjDateAdd([Actual Start],[Duration1],[Project
Calendar]))

Is "NA" considered to be "null" in project? Is there a formula for
if
ACT
ST is null populate finish 1 with NA?

:

KLA --

To "trap" for an NA value in a Date field, you need to use the
following
Function:

IIF([Actual Start] = ProjDateValue("NA), truepart, falsepart)

So, rewrite your original formula using the above. Hope this
helps.




I am attempting to customize the finish 1 field. I want the value
to
be
calculated based on the Actual Start date + 40 days duration
(which I
have
used duration 1, populated with 40d) based on my project calendar.
This
formula works and gives the value that I expected however if the
Actual
Start
date has not yet been populated (tasks that have not yet started)
and
the
current value is NA I am receiving an error message in the
customized
finish
1 field. How can I modify my formula to ignore the "NA"'s in the
Actual
start column? The following is the current formula:

ProjDateAdd([Actual Start],[Duration1],[Project Calendar])