You are here:
ISPICKVAL
Determines if the value of a picklist field is equal to a text literal you specify.
Use
ISPICKVAL(picklist_field,
text_literal) and replace picklist_field with
the merge field name for the picklist; replace text_literal with the picklist
value in quotes. text_literal cannot be a merge field or the result of a
function.
Tips
- Replace picklist_field with a custom or standard field of type picklist.
- Your text_literal expression must be of type text and enclosed in quotes. It cannot be a merge field or the result of a function.
- Use CASE functions to determine if a picklist value is equal to a particular value.
- When using the ISPICKVAL function to return the previous value of a picklist field, include
the PRIORVALUE function inside the ISPICKVAL function as in this
example:
ISPICKVAL(PRIORVALUE (picklist_field), text_literal)
IF(ISPICKVAL(Status, "Activated"), NOW()-ActivatedDate,
null) calculates the number of days since the contract was activated. If the contract
status is not “Activated,” this field is blank.
IF(ISPICKVAL(StageName, "Closed Won"),
ROUND(Amount *0.02, 2), 0)This example calculates the commission amount for any opportunity that has a “Closed Won” stage. The value of this field is the amount times 0.02 for any closed/won opportunity. Open or lost opportunities have a zero commission value.
ISPICKVAL(Stage, “Closed Lost”) && INCLUDES(Competitor__c, “Acme”)