Formula in Enterprise Text field error

[Conrad Santiago]

Case 1: I customize a Text Field to read an Enterprise Project Outline Code.
When I display the column, the data is there.

Case 2: When I customize an Enterprise Text Field to read the same
Enterprise Project Outline Code and I display the column, the cells are
filled with #ERROR.

In both cases, I set the Text Field to a Formula that contains this:

[Enterprise Project Outlne Code7]

How can I get the data to show up correctly in Case 2?

Thanks in advance for any response.
--Conrad Santiago

 

[JackD]

Did you try looking for

[Enterprise Project Outline Code7] ?

There looks like there was a misspelling in your original formula.

 

[Conrad Santiago]

Good catch, Jack. I misstyped it when I wrote this message. For the code,
however, I selected it from the Fields button, so the spelling was correct in
the formula.

Funny thing, though...I am not getting the error any more and the correct
data is in there. There must have been something that triggered it.

Thanks!
--Conrad Santiago

Did you try looking for

[Enterprise Project Outline Code7] ?

There looks like there was a misspelling in your original formula.


--
-Jack ... For project information and macro examples visit
http://masamiki.com/project

..

Case 1: I customize a Text Field to read an Enterprise Project Outline Code.
When I display the column, the data is there.

Case 2: When I customize an Enterprise Text Field to read the same
Enterprise Project Outline Code and I display the column, the cells are
filled with #ERROR.

In both cases, I set the Text Field to a Formula that contains this:

[Enterprise Project Outlne Code7]

How can I get the data to show up correctly in Case 2?

Thanks in advance for any response.
--Conrad Santiago