Loading

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

게시 일자: Oct 13, 2022
상세 설명
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."
솔루션

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 기사 번호

000380973

 
로드 중
Salesforce Help | Article