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.

Required Editions

Available in: Salesforce Classic and Lightning Experience
Available in: All Editions
User Permissions Needed
To create or change custom fields: View Setup and Configuration

Follow these steps to get an email notification for custom picklists that have more than 4,000 values.

  1. From Setup, in the Quick Find box, enter Settings, and then select Picklist Settings.
  2. In the Picklist Settings window, click Email Me to receive an email with the picklist fields and the number of inactive values.
    List of Custom Picklist Fields With Inactive Values

In the email, click the picklist name to go to the picklist field page and delete any inactive unused values.