This article explains a phenomenon where unintended "Invalid Values" are added to a Picklist field when Service or Sales records are created or updated using the Data Loader or Data Import Wizard.
This behavior occurs when the "Restrict picklist to the values defined in the value set" setting is disabled.
Overview
This is the expected behavior based on standard Salesforce functionality.
Cause
If the "Restrict picklist to the values defined in the value set" checkbox is unchecked (disabled) in the picklist field settings, Salesforce accepts the value and adds it to the list as an "Invalid Value" when data containing a value not defined by the administrator is imported.
Solution
To prevent data other than the defined values from being imported, enable the restriction using the following steps:
Enabling this setting will cause an error when attempting to import or update records that contain an undefined value, preventing unintended values from being added to the system.
005228870

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 are necessary for basic website functionality. Some examples include: session cookies needed to transmit the website, authentication cookies, and security 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 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.