Use a dependent picklist to help your users enter accurate and consistent data. A
dependent picklist is a custom or multi-select picklist for which the valid
values depend on the value of another field, called the controlling field. A
controlling field can be any picklist (with at least one and fewer than 300 values) or checkbox
field on the same record.
Required Editions
Available in: both Salesforce Classic and Lightning Experience
Available in: All Editions
Example
For example, you can define a Reason custom picklist on opportunities and make its valid
values depend on the value of the Stage picklist like this:
If Stage is Closed Won, the valid values for Reason are Superior features or Lower
price.
If Stage is Closed Lost, the valid values for Reason are Inferior features, Higher
price, or Company viability.
Use the Field Dependency Matrix The field dependency matrix lets you specify the dependent picklist values that are available when a user selects each controlling field value. The top row of the matrix contains the controlling field values, while the columns list the dependent field values. Use this matrix to include or exclude values. Included values are available in the dependent picklist when a value in the controlling field is selected. Excluded fields aren’t available in the dependent picklist for the selected controlling field value.
Delete Picklist Dependencies If you no longer want the values of a dependent picklist to depend on a controlling field, delete its dependency. Deleting the dependency removes the logic that defines how the values of the picklist depend on the controlling field, but doesn't delete the fields or affect their data.
We use three kinds of cookies on our websites: required, functional, and advertising. You can choose whether functional and advertising cookies apply. Click on the different cookie categories to find out more about each category and to change the default settings.
Privacy Statement
Required Cookies
Always Active
Required cookies are necessary for basic website functionality. Some examples include: session cookies needed to transmit the website, authentication cookies, and security cookies.
Functional Cookies
Functional cookies enhance functions, performance, and services on the website. Some examples include: cookies used to analyze site traffic, cookies used for market research, and cookies used to display advertising that is not directed to a particular individual.
Advertising Cookies
Advertising cookies track activity across websites in order to understand a viewer’s interests, and direct them specific marketing. Some examples include: cookies used for remarketing, or interest-based advertising.
