Loading
Ongoing maintenance for Salesforce HelpRead More
Feature degradation | Gmail Email delivery failureRead More

ISPICKVAL() function does not work for a specific picklist value

Publish Date: Oct 13, 2022
Description
You have created a formula for a formula field, workflow rule, process, validation rule, etc. and it's working for all values except for one.

Example:

You have a custom "Fruit" picklist field with the following values: "Apple," "Banana," "Cherry," "Durian," ...

You have created a formula field that will return A, B, C and D respectively if the corresponding picklist value is selected. Apple, Banana, Durian and everything else is working except for "Cherry."
Resolution

Navigate to the picklist field used in the formula and look for the picklist value that was not working. Check if the "API Name" listed for the picklist value is exactly the same as the one shown in the "Values" column. If not, use the API Name instead for the ISPICKVAL() function in the formula. It should work afterwards.

The ISPICKVAL() function uses the API Names of the values and not the actual values itself. Usually these values are the same but if the picklist value had been renamed, the API Names are not changed unless manually modified to match the new picklist value name.

See Also: Tips for Building Formulas
Knowledge Article Number

000380973

 
Loading
Salesforce Help | Article