1

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

1

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.

1
  • 1
    Thanks a lot for your answer. Nevertheless, this is work around. It would be great to have function that can differ between label and api name. Jun 26, 2018 at 10:13

You must log in to answer this question.

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