Enterprise fields: formulas not working in Project level fields

[Phyl]

Hi all,

I'm working on the Enterprise Global Template 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

 

[Brian K - Project MVP]

Hi all,

I'm working on the Enterprise Global Template 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

It is because you are asking a project level field to calculate off of
a task level value. This will work if you use an Enterprise Task TExt
field and an Enterprise TAsk Date field.

--
___
Brian K
Project MVP
http://projectified.typepad.com

Project Server Consultant
www.quantumpm.com

 

[Phyl]

It is because you are asking a project level field to calculate off of
a task level value. This will work if you use an Enterprise Task TExt
field and an Enterprise TAsk Date field.

Thanks, Brian. So does that mean there's no way to obtain a piece of
data (in this case, a date) from a specific task to show at the
project level? I'm trying to get this single date to show up in
Project Center, which can only be accessed via Enterprise Project
tasks.

Cheers,
Phyl