You need to sign in to do that
Don't have an account?

Case function in formula field limit exceeds
Hi ,
I have new request from my enduser to update the formula field. State_Code__c is the custome text field that stores the state code and country_code__c is the formula field that stores country code based on Sate_code__c. used the case function in the formula to get the corect country code. Now we have added 4 new countrys so i need to extand tha case function with 50 extra states but unfortunatly the limit is exceeds and i am unable to do with case function . Can anyone please help me to sortout this issue .( ie. one country have many states but i am unabel to add or function in case.)
kInd Regards,
Patchala
I have new request from my enduser to update the formula field. State_Code__c is the custome text field that stores the state code and country_code__c is the formula field that stores country code based on Sate_code__c. used the case function in the formula to get the corect country code. Now we have added 4 new countrys so i need to extand tha case function with 50 extra states but unfortunatly the limit is exceeds and i am unable to do with case function . Can anyone please help me to sortout this issue .( ie. one country have many states but i am unabel to add or function in case.)
kInd Regards,
Patchala
If your formula field limit exceeds, then you cannot able to include more conditions into that..Only option is to go with apex code or trigger..
Thank You
• Reduce formula character (remember Character count includes spaces, carriage returns, and comments) if possible
• Introduce secondary formula field
• Leverage workflow field update
Thanks
Jagannath