Hi,

 

I wrote a formula on the Sandbox on picklist. (See case statement below).  On the sandbox the formula size is about 3000, but when I copy it to production it tells me I am over limit and the size is about 6000.  Why is that?  When I copied to word, that also tells me that size is 3000.  Please help.

 

CASE (   SelectAreaTeam__c ,
'A NorthEast Project','A NorthEast Project',
'Alabama Project','Alabama Project',
'Alaska','Alaska',
'Appalachian','Appalachian',
'Arkansas','Arkansas',
'Baltimore','Baltimore',
'Bay','Bay',
'Bergen County Catalyst','Bergen County Catalyst',
'Big Sky','Big Sky',
'California Central Coast','California Central Coast',
'Capitol','Capitol',
'Carolinas','Carolinas',
'Chicago Urban Sending','Chicago Urban Sending',
'Colorado Rockies','Colorado Rockies',
'Columbia Pacific','Columbia Pacific',
'DelMarPa','DelMarPa',
'Desert Valleys','Desert Valleys',
'Dirigo Maine','Dirigo Maine',
'Downeast Maine','Downeast Maine',
'East Metro','East Metro',
'East Texas','East Texas',
'Eastern NY','Eastern NY',
'E-Z Pass','E-Z Pass',
'Fairfield County Catalyst','Fairfield County Catalyst',
'Finger Lakes NY','Finger Lakes NY',
'Florida','Florida',
'Friends Across New England','Friends Across New England',
'Grand Canyon','Grand Canyon',
'Greater Chicago','Greater Chicago',
'Greater Cincinnati','Greater Cincinnati',
'Greater Cleveland','Greater Cleveland',
'Greater Dayton','Greater Dayton',
'Greater Illinois','Greater Illinois',
'Greater Los Angeles','Greater Los Angeles',
'Greater Puget Sound','Greater Puget Sound',
'Greater West Metro','Greater West Metro',
'Hawaii Catalyst','Hawaii Catalyst',
'Head of the Lakes','Head of the Lakes',
'Heartland KS','Heartland KS',
'Inland Empire','Inland Empire',
'Kansas City','Kansas City',
'Louisiana','Louisiana',
'Massachusetts Bay','Massachusetts Bay',
'Michigan','Michigan',
'Midland','Midland',
'Milwaukee','Milwaukee',
'Minn-Kota','Minn-Kota',
'Miss Tennky','Miss Tennky',
'Missouri Gateway','Missouri Gateway',
'Monmouth County Catalyst','Monmouth County Catalyst',
'New Jersey','New Jersey',
'New Mexico','New Mexico',
'North Central Tier NY','North Central Tier NY',
'North Central Wisconsin','North Central Wisconsin',
'Northeast Ohio','Northeast Ohio',
'Northern Chicago Catalyst','Northern Chicago Catalyst',
'Northern Illinois','Northern Illinois',
'Northern Texas','Northern Texas',
'Northwest California','Northwest California',
'Northwest Central','Northwest Central',
'Northwest Ohio','Northwest Ohio',
'Ohio River Valley','Ohio River Valley',
'Okazark','Okazark',
'Oklahoma','Oklahoma',
'One World','One World',
'Orange County','Orange County',
'Pacific Cascades','Pacific Cascades',
'Pine to Prairie','Pine to Prairie',
'Quad City Catalyst','Quad City Catalyst',
'San Diego','San Diego',
'Sierra San Joaquin','Sierra San Joaquin',
'Silver & Gold','Silver & Gold',
'South Texas','South Texas',
'Southern CA Mtn & Desert','Southern CA Mtn & Desert',
'Spokane Catalyst','Spokane Catalyst',
'Steinbeck Coast','Steinbeck Coast',
'Team 500','Team 500',
'Texas Gulf Coast','Texas Gulf Coast',
'The Grand South','The Grand South',
'Virginia','Virginia',
'Visit Michigan','Visit Michigan',
'Wasatch-Teton','Wasatch-Teton',
'Waukesha and West','Waukesha and West',
'West Texas','West Texas',
'Western NY','Western NY',
'Western PA','Western PA',
'World Class','World Class',
'World Flags','World Flags',
""
)