Loading
Sales Performance Management
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
            switch

            You are here:

            1. Salesforce Help
            2. Docs
            3. Sales Performance Management

            switch

            Compares an input value against a list and returns a corresponding value or error message in Salesforce Spiff. This function is similar to the vlookup() function except the lookup tables are specified within the function rather than in a lookup table.

            Required Editions

            Available in: both Salesforce Classic (not available in all orgs) and Lightning Experience
            Available in: Enterprise, Unlimited, and Developer Editions
            Available for an additional cost in: Professional Edition with Web Services API Enabled

            Syntax

            switch(value_to_switch, list_of_value_and_result_pairs)

            Arguments

            Argument Required? Description
            lookup_value Required The record or value that you want to compare.
            list_of_value_and_result_pairs Required A list of value pairs, where each pair includes a value to match against lookup_value and a return value for that match. Enclose the list in brackets with comma-separated values. To specify an error message, such as when the list doesn't include lookup_value, the last item in the list can be a string that you want to show to admins.

            Example

            The Corporate AE Plan has a 10% commission rate and the Enterprise AE Plan has a 12% commission rate. Look up the plan name and apply the appropriate commission rate. Show an error message if the plan name isn't included in the list.

            =switch(plan.name, ["Corporate AE PLan", "10%", "Enterprise AE Plan", "12%", "We couldn't find a rate for that plan name."])
             
            Loading
            Salesforce Help | Article