The State and Country picklist feature adds picklists to standard address fields. Unfortunately the address field type is not available for creating new custom fields, so it's not possible to add them to custom objects.
From the documentation:
State and country picklists are available in the shipping, billing,
mailing, and “other” address fields in the ...
Few challenges which I encountered during the upgrading of a package for picklist:
New Picklist Value does not get added.
Change in default Picklist Value.
The only solution is, either the post-deployment activity or reinstalling the package, Or have some scripting logic that automatically does for you.
I also faced the same challenges with : Field ...
Did you try using priorvalue to check what it was before and what it is now?
Something like this should work for the entry criteria where you check if it used to be 4 and if it is now 3,2,1.
PRIORVALUE(ISPICKVAL(Forecast_Category__c, "4") &&
ISPICKVAL(Forecast_Category__c, "3") ||
ISPICKVAL(Forecast_Category__c, "2") ||
You could use record types to achieve this. On object ‘A’s’ open and active update the child record’s record type that has only open and active in the picklist values. Similarly when the status is Closed update the child record type that would have only Closed as an option. So you would need two different record types to accomplish this.
Using replace will replace the picklist value completely across all record types.
Data Loader with bulk API is your best bet. You'll just have to analyze if there's any workflows or logic you might trigger in an update that you'd want to avoid, otherwise you listed the steps.
Create your new picklist value
Query/Pull the necessary records ...
The best way to solve this issue is to write a short batchable to make the changes. Generally your Excel will crash with that many records when you export/import through data loader.
It would work in the following manner:
Add the new picklist values to the picklist
Create the batchable class (you can base yourself on the one below), test it and deploy to ...