You need to sign in to do that
Don't have an account?
Creating a Field that References a Pick List
Hi Everyone,
I was trying to create a new field based off of a formula using a field within our opportunity, which is a picklist. I figured out that it cannot just pull a picklist value and has to be transferred to "TEXT" first. So I went through and created the formula that I thought would be needed to get the values for the new field based off of the picklist. When I check the syntax, I get an error stating:
"Error: Compiled formula is too big to execute (5,637 characters). Maximum size is 5,000 characters"
The formula is only:
745 Characters w/out Spaces
775 Characters w/ Spaces
So I'm not really sure what's going on. Would someone be able to shed some light on the issue and/or what might be going on? The formula I was trying to use is provided below:
IF(ISBLANK(TEXT(Inspection_City__c)), "None",
IF(CONTAINS(TEXT(Inspection_City__c), "Atwater:Ballico:Delhi:Dos Palos:Gustine:Hilmar:Livingston:Los Banos:Merced:Santa Nella:Stevinson:Winton"), "Merced County",
IF(CONTAINS(TEXT(Inspection_City__c), "Ceres:Denair:Grayson:Hughson:Keyes:La Grange:Modesto:Newman:Oakdale:Patterson:Riverbank:Salida:Turlock:Waterford"), "Stanislaus County",
IF(CONTAINS(TEXT(Inspection_City__c), "Escalon:Lathrop:Lockeford:Lodi:Manteca:Ripon:Stockton:Tracy"), "San Joaquin County",
IF(CONTAINS(TEXT(Inspection_City__c), "Dublin:Hayward:Livermore"), "Alameda County",
IF(CONTAINS(TEXT(Inspection_City__c), "Galt"), "Sacramento County",
IF(CONTAINS(TEXT(Inspection_City__c), "Gilroy:Morgan Hill:Mountain View"), "Santa Clara County", "Outside Area")))))))
Any guidance would be appreciated.
Thanks,
Nathan
Although it appears to be less characters, the TEXT operator expands to something much bigger.
Perhaps rather than a formula field you could do it with a workflow field update to a custom field? That is, put this same formula into the field update formula. You usually get higher character limits on those.
Hi *werewolf*,
Just wanted to drop in and say thanks for the response, I got sidetracked for quite a while about this. We actually have a very basic version of SFDC that I'm finding does not have a lot of the usual functionality, including workflow rules :( It was worth a shot though ^_^
Thanks