function readOnly(count){ }
Sign Up ›
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
Learn More

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
S&PCRMCherylS&PCRMCheryl 

Calculated Region field on accounts and contacts

Hi All,

 

I'm wondering if anyone has been able to do this and could explain how they got around the 5k limit in formulas.  What I'm trying to do is build a formula based on Country in Accounts and Contacts to determine the region.  I keep running into the issue of too many characters in the formula.  I tried making multiple formula fields, but have found once you compile into one field it considers characters from all formula fields when making this character count. 

 

Any suggestions??

 

Cheryl

hhuiehhuie

The only workaround that I've been told is either use Workflow Rules to break the string of Formula fields or Coding (Trigger, S-Controls).

 

Can you post your formula field so that we can take a look at it?

 

Thanks