AnsweredAssumed Answered

Display lookup value description instead of ID in a calculated field?

Question asked by BradGibson on Jul 31, 2013
Latest reply on Aug 8, 2013 by BradGibson
How do I show the lookup value description instead of ID in a calculated field?

I have a lookup based string field in a secured sub-page to limit who can edit the values. But I need to allow EVERYONE to see the value of the field, so I created a read-only calculated attribute, hoping to populate it with the value of the field in the secured sub-page.
When I do that I get the lookup value CODE instead of the DESCRIPTIVE text label of the value. Which is what I want.. the CODE is not user friendly.

I do not want to have to update the idea/project to populate the Read Only field... so I dismissed the idea of using a process to populate the read-only field.

How can I tell the calculated attribute to use the description instead of the lookup code?

Thanks!

BG

Outcomes