[SalesForce] How to display Picklist Label, instead of Picklist API in a Formula Field

I think the title says it all, we are using picklist values having different Label and API Name. How can I display the Picklist label instead of API in when using a formula field. I know I can use IF statements and ISPICKVAL but is there a more dynamic solution, so that when new picklist values are added no need to edit the formula again.

Sample Picklist Values

Small Business – SAP_A

Medium Business – SAP_B

Best Answer

Unfortunately this feature does not seem to exist yet. Vote for this Idea:

Allow Picklist Value Labels in Formulas

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).

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

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

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.

Related Solutions

[SalesForce] Workflow Field Update formula function TEXT() using picklist API values, not label values

So I have found a workaround...with help from Salesforce:

Under "Data Management" -> "Picklist Settings" enable the sole setting of "Disable editing picklist values' API names"
Go to your picklist field and delete the entry
Add the value back into the picklist

By default the API Name is an exact copy of the Value, it includes spaces, special characters etc.

By enabling the first setting I can avoid encountering this problem by stopping the developers playing with the API names...

[SalesForce] Fetch Label of picklist value instead on API in lightning

To get the label, you're simply going to need to find the correct label based on the value. Here's one way you can do that:

var value = event.getSource().get("v.value"),
    labelForValue = component.get("v.customerGroupPicklist")
    .reduce( (a, v) => a || (v.value == value? v.label: ""), "");

Where "reduce" is an array function that is used to reduce the values of the array to a single value, in our case, the label that we're interested in looking for. This isn't the only possible solution, but just one of several that would work.

Best Answer

Allow Picklist Value Labels in Formulas

Related Solutions

[SalesForce] Workflow Field Update formula function TEXT() using picklist API values, not label values

[SalesForce] Fetch Label of picklist value instead on API in lightning

Related Topic