Allow Picklist Value Labels in Formulas - Ideas - Salesforce Trailblazer Community
Trailblazer Community

All Ideas

Idea Details

Post an Idea
12,070  Points
Idea has been posted. Give it an upvote or downvote.

Allow Picklist Value Labels in Formulas

Process Automation

Spring '17 brought "API Names" to picklist values so that integrations can use a "hidden" value (the API name) while users can see a local or more friendly value (the label).

User-added image

However, there isn't a way to access the label in formulas.

User-added image

So, if you want a formula to display the picklist's value somewhere else in Salesforce, only the API name will appear.

User-added image

This will be confusing to users if you actually have different values for API name and label, as they may not be familiar with the API name. We need a way to access the value's label in formulas. SOQL has a toLabel() function, and we need its equivalent in formulas as well.

Merge Idea · Flag

Latest Comment from Salesforce

  • Vladimir Gerasimov - 1 year ago

    Hi there,

    First of all I want to say that we understand the importance of this idea and it's on our backlog to get implemented at some point. Unfortunately, right now I don't have a better timeline for you, this is not currently scheduled for the next couple of the releases, but we are constantly reevaluating our plans, and hopefully we will be able to address this gap sooner than later.

    Thanks for your comments and votes!
  • Upvotes
  • Downvotes



from AppExchange

Help us to keep IdeaExchange clean by pointing out overlapping ideas. We'll investigate your suggestion and merge the ideas if it makes sense.



Thanks for your merge suggestion. We will review it shortly and merge the ideas if applicable.

Salesforce takes abuse situations very seriously. Examples of abuse include but are not limited to posting of offensive language or fraudulent statements. To help us process your request as quickly as possible, please fill out the form below describing the situation. For privacy and security reasons, the final outcome of an abuse case may not be revealed to the person who reported it.


Thank you for your feedback. We take abuse seriously and will investigate this issue and take appropriate action.