I am having confusion in understanding Picklist limitations. As of now, I have assumption that I can have 1K picklist values for Single picklist(not a multi picklist).
Quote from Documentation:
Unrestricted picklists can have up to 1,000 active values.
However, I am able to create more than 2000 active values. What I tried – created 1001 values, then deactivated them and then created 1K values again. Later I activated the 1001 values. So with this, now I have more than 2K values.
I am unsure about the final limit.
UPDATE: 500 picklist limits for the multi-picklist can also be
breached. [This also needs to be unrestricted].
If anyone aware could you please let me know the final limits for picklist values.
Best Answer
What you've found is a bug in the platform. Generally speaking, when the documentation says that a particular limit exists, and you find a way to work around it, then there's a bug. It is possible that this will be addressed in a future release, so you should not rely on this working in the future. Note that, as far as I'm aware, Salesforce itself is capable of handling at least 2,000 total picklist values, but it isn't meant to have more than 1,000 active values at a time. Attempting to do so may work in a particular org, but I would expect challenges when attempting to migrate this configuration to different orgs using any of the available metadata tools (Change Sets, Metadata API, DX).