Enterprise Custom Field that calculates another Custom Field

[Brian Lukanic]

Can this be done at the project level? You can't create custom enterprise
fields in the fat client at the project level, but you can on the web admin
area. OK fine, so although I like using the fat client I know how to do it on
the web area. The validation step doesn't seem to like something when it
checks the formula in Project:

Every time I create my second custom enterprise field and enter the formula
that includes "[custom field #1]" the end result displays "#ERROR."

I have confirmed that the first custom project-level enterprise field is
populated, so I know that's not the problem. I also know that I have the
formula syntax correct, because if I do this in the fat client with two text
fields I can get the expected result.

 

[Brian Lukanic]

I ended up solving my own problem. For in the interested of historical
posterity, let me post the answer in case anyone else runs into this:

* You can indeed to a project-level custom formula that calculates of
another custom formula.
* The #ERROR messages become difficult to get rid of if at any point your
Project file started out with a formula that was truly an error - even after
fixing that formula to be correct, you'll run into trouble getting rid of it.
I even tried simple formulas such as "=1" and they failed. So I knew
something was goofy from legacy stuff I had done.
* Best solution is this: Once you've got your enterprise formulas working
correctly, delete all of the old ones on Server, and also start over with a
new .mpp that connects to Server. The formulas WILL then work.

 

[Marc Soester [MVP]]

Hi Brian,

yes you can associate project custom fields to other project custom fields