Dan --
What version of Project Server are you using? 2002, 2003, or 2007? This
information is important because it determines how and where you create the
formula. I'm going to assume that you are using Project Server 2003.
First of all, I recommend you use a custom enterprise project Duration field
for your custom field formula. If you use a custom Duration field, you can
use the following formula:
ProjDateDiff([Last Update],[Current Date])
The above formula assumes the Standard calendar, so you don't need to
include it in the formula, nor do you need to divide by 480 because you are
using a Duration field. To answer your other questions:
1. In the Formula dialog in Project Professional, you can see a list of ALL
available fields by clicking the Field pick list button and then examining
the fields shown in every section of the list. I found the above two fields
in the Project - Date section of the pick list.
2. When you create a new custom enterprise Project or Task field, each PM
needs to open and recalculate their current projects by pressing the F9
function key. They can then save and publish the project. Your PM's will
not need to do this with any new projects created AFTER you created the new
custom field.
If you are using 2007, by chance, then I'll give you a trick. Project
Server 2007 wants you to create all custom enterprise Project fields in the
PWA interface, right? And that interface does not show you a list of
available fields from which to pick, right? To get around this problem,
temporarily create a custom local TASK field in Project Professional to
create the formula you want to use in the enterprise Project field. I
usually open an actual project Read-Only, create the temporary Task field
with the formula, and then test it. When you add the temporary Task field
to any Task view, such as the Gantt Chart view, you can test the field by
looking at the results in the Project Summary Task (Row 0). If the formula
works correctly, then copy and paste it into the Formula section of the
field definition in PWA, and then close the Read-Only project without saving
it. In fact, you can even use the same trick with custom enterprise Task
and Resource Fields as well. Hope this helps.
Dan said:
I am trying to calculate (AGE) how many days it has been since a project
was
last published. I try several field names in the formula but all have
errors.
Both Last Published, and Last Modifed show up in my views but I cant use
them in a custom field formula: =(ProjDateDiff([Last Modified],[Current
Date],"Standard")/480)
1. Where can I get a list of Valid Field names which can be used in a
formula?
2. Could someone verify that when I create a formula it does get executed
until I open and save the project?
Thanks
