Calculate Enterprise Project field from value of named task?

[scubaal]

Using Project 2003 Pro + Server.
Is is possible to create an Enterprise Field that is a formula that
takes its value from the Actual Finish date of a task in the project.

Example:
We *always* have a task called 'Request Brief', which is completed
when the project owner has requested the breif.

I would like a Enterprise Field that gets the Actual finish date of
'Request Brief'. Is that possible?
I could then have a 2nd Enterprise field that would be a duration -
that is the no of days between 'request brief' and now.


I just cant work out whether its possible to get a value from a named
task?
Any ideas?


Thanks
Al

 

[Marc Soester [MVP]]

Hi scubaal,

I dont believe that you are able to check for a task name within formulars.
I would think that this would only be possible via Macros ( or VBA).

may I suggest another option:
What you can do is have another custom field ( a flag field). Click yes to
all tasks you which to read out the actual finish date. Then you can create a
formula in another field reading out if the flag field has a yes or no ( true
or false). If true, then return the actual finish date. That may does the
job.
All you need to ensure is that the flag is ticked correctly
hope this helps