Loading

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

Publiceringsdatum: Oct 13, 2022
Beskrivning
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."
Lösning

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-artikelnummer

000380973

 
Laddar
Salesforce Help | Article