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?

1 Answer 1


You can use formula to convert API name back to label with case statement.

  "API 1", "Label 1",
  "API 2", "Label 2",

PS: you will need to update your formula whenever you updates pick list values.


You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .