Manage Inactive Picklist Values

Inactive picklist values can be a result of an import or intentionally removing the value from the list of available values for future use. In certain cases, importing text fields can create numerous unwanted picklist fields. Managing your inactive picklist values and enforcing limits on inactive values for unrestricted picklists can improve performance and improve your Salesforce org’s overall health.

Available in: both Salesforce Classic and Lightning Experience

Available in: All Editions

• Get a List of Custom Picklist Fields with Inactive Values
  Get email notifications when custom picklist fields have more than 4,000 inactive values and then use this information to bulk delete the inactive unused values. This feature is available only for custom picklists with predefined values.
• Bulk Delete Inactive Picklist Values
  Managing your inactive picklist values and enforcing limits on the number of inactive values for custom picklists can improve performance and the overall health of your Salesforce org. If you have a picklist with a large number of inactive unused values, you can bulk delete them.
• Establish a Picklist Upper Bound Limit
  You can enforce an upper bound limit of inactive values on existing picklists. The limit is enforced on the inactive values of unrestricted, custom picklists whose numbers don’t exceed the allowable limit. By default, all new unrestricted picklists have an enforced limit of 4,000 inactive values.
• Convert a Text Field to a Picklist Field
  By default, an upper bound limit of 4,000 is applied to inactive unrestricted picklists for each field. If you exceed this limit when converting a text field to a picklist field, you get an error message.