Enterprise fields: formulas not working in Project level fields

[cdrivanova]

Hi all,

I'm working on the Enterprise Global Template (MS Project Server 2003) and have created the following custom fields:

Enterprise Task Text2 "Milestone Type"
Enterprise Project Date1 "PA"

In the Enterprise Project Date1 custom field, I have the formula:
IIF([Enterprise Text2] = "PA", start, 0)

i.e., if the text in Enterprise Text2 = the text "PA", then populate Enterprise Project Date1 with the start date of the task.

Now, this formula works at the local level (using custom fields in a single project file). The formula also works if you define an Enterprise TASK Date1 field with the same formula. However, I cannot get the Enterprise PROJECT Date1 formula to work.

I tried to do kind of an odd workaround, by defining Enterprise TASK Date1 using the formula and then having Enterprise PROJECT Date1 = Enterprise TASK Date1, but I just get "NA" as my answer in Enterprise PROJECT Date1.

Any helpful hints?

Thanks,
Phyl