Enterprise Custom Fields Formula Error

S

songmu

I've created an enterprise task custom text field
and used the formula "DATE()" in my global template.

when I create new project, it works well and the custom text field show
current date.
but I open a project which created before added the custom text field.
it works wrong and the field's value is #ERROR.

Can anyone help me here by either giving me a direction,
or telling me that I simply can't do what I want to do.
 
D

Dale Howard

songmu --

Did you try recalculating the project by pressing the F9 key while the
project is open? One of the little quirks of enterprise custom fields is
that the values in the field won't appear until you recalculate the project
for the first time after the field is displayed in the project. Let me know
if this helps.

--
Dale A. Howard
Enterprise Project Trainer/Consultant
Denver, Colorado
http://www.msprojectexperts.com
"We wrote the book on Project Server"
 
S

songmu

thanks for your help.

when pressed the F9 key, it is displayed. but I didn'y ask the user to press
F9 key, so I want to use the macro function to recalculate the project, How
can I do?
 
D

Dale Howard

sonmu --

I would strong recommend that you teach your project managers about pressing
the F9 key. The other thing they can do is to take an action in the project
that causes the software to recalculate automatically, such as changing the
Duration of a task, setting a dependency, etc. Skip the macro. It isn't
worth the time and effort. Hope this helps.
 
S

songmu

thanks for your help

Dale Howard said:
sonmu --

I would strong recommend that you teach your project managers about pressing
the F9 key. The other thing they can do is to take an action in the project
that causes the software to recalculate automatically, such as changing the
Duration of a task, setting a dependency, etc. Skip the macro. It isn't
worth the time and effort. Hope this helps.
Click to expand...
 
Top