Get picklist value LABEL in formula field

Question

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?

identigral · Accepted Answer · 2021-11-21 08:59:50Z

2

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.

identigral

7,81434 gold badges33 silver badges45 bronze badges

answered Jun 26, 2018 at 10:07

AtulRajguru9

9,1603 gold badges30 silver badges66 bronze badges

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.
– Vladimir Egikyan
Commented Jun 26, 2018 at 10:13
Works, real PIA when the picklist is huge. There is a character limit on formula field (3900 characters?) help.salesforce.com/s/articleView?id=000385147&type=1
– Jeremy A. West
Commented Nov 7, 2023 at 16:23

Add a comment |

1 Answer 1