Loading
Extend Salesforce with Clicks, Not Code
Table of Contents
Filter by (0)Add
Select Filters

          No results
          No results
          Here are some search tips

          Check the spelling of your keywords.
          Use more general search terms.
          Select fewer filters to broaden your search.

            Search all of Salesforce Help
            Search all of Salesforce Help
            ISPICKVAL

            You are here:

            1. Salesforce Help
            2. Docs
            3. Extend Salesforce with Clicks, Not Code

            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)
            Contract Activation Example
            Contract Activation Example

            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.

            Commission Accounts Example
            Commission Accounts Example 
            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.

            Competitor-Triggered Workflow Example
            Competitor-Triggered Workflow Example 
            ISPICKVAL(Stage, “Closed Lost”) && INCLUDES(Competitor__c, “Acme”)
            In a workflow rule or process, this formula configures Salesforce to trigger the associated actions if the Competitor multi-select picklist field on a lost business is Acme.
             
            Loading
            Salesforce Help | Article