can you change state in the standard address field to a picklist?
Or do I have to create new custom fields for each item:
state(this would be my new picklist)
region (new picklist)
country (new picklist
The main issue is that we have been using the standard address field for a few years, now we want to improve our data so we need to have picklist so we dont get a lot of variations of countries (US, USA, United States etc...)
but if we create new custom fields for the all the address details, then I have to still have the old standard address field on the page layout plus the new ones, or we will not beable to see the old addresses entered in when using the standard address field
I hate to have 2 lists for address in our lead page layout to show old leads addresses and the new ones with the picklists.
The only other way to do this would be to create your own custom addres fields and then use a formula field to concatenate them all together to look like an address in a single field.
Alternatively take a look at data quality solutions such as DataScout.