Loading

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

Data pubblicazione: Oct 13, 2022
Descrizione
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."
Risoluzione

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
Numero articolo Knowledge

000380973

 
Caricamento
Salesforce Help | Article