Salesforce Stack Exchange is a question and answer site for Salesforce administrators, implementation experts, developers and anybody in-between. It only takes a minute to sign up.
Sign up to join this community
My question can sound trivial, but the issue below seems to be serious.
We can use TEXT(field) to get picklist value in formula field.
The issue is that this method returns API name of particular value and not label.
Does anybody know if we can obtain Label of picklist value?
You can use formula to convert API name back to label with case statement.
CASE(TEXT(field),
"API 1", "Label 1",
"API 2", "Label 2",
"Error"
)
PS: you will need to update your formula whenever you updates pick list values.
