How to refer to an Enterprise Task Outline Code Description field in a Formula

[brentridenour]

I need to set the contents of a custom Enterprise Text field based on
the value filled in by the user in an Enterprise Task Outline Code
field (The values are in a lookup table). By using a formula, I can
set the Enterprise Text field to the value of the Enterprise Task
Outline Code field by the formula "[Enterprise Task Outline Code1]",
but what I need is the description for [Enterprise Task Outline Code1].
How do I reference the description value for an Enterprise Task
Outline Code field in a formula?

 

[Dale Howard [MVP]]

brentridenour --

There is no direct method to "grab" the description information from a value
in a custom enterprise outline code field. The indirect method is to use
the SWITCH formula in the field that references the outline code. In the
SWITCH field, you can test for a value, and if true you can specify a value,
which would be the description you want shown in the field. Consider the
following example:

SWITCH([Enterprise Task Outline Code1]="Some Value", "Some Description",
[Enterprise Task Outline Code1]="Some Other Value", "Some Other
Description", etc.)

You would need to set up a test for every value in your custom enterprise
outline code field and then manually enter the description for each value.
Hope this helps.