Does anyone know a workaround of the 5000 character limit on a formula field without having to create a trigger?

I am trying to get the country ISO codes using a case statement but I'm hitting the 5000 character limit. I could quickly write a trigger and utilize custom settings for this but I don't know if there a quick hack I could utilize.

  • 1
    Not that I know of, even if you miss the bullet today you will end up dead sooner or later when there is more to add. – Rao Feb 28 '14 at 21:27
  • 1
    Note you can get ISO Country codes for free if you use the optional State and Country picklists - e.g. for Leads and Accounts; – cropredy Mar 1 '14 at 2:36

Instead of using a formula field, you can switch to a workflow and field update, which is not subject to this same 5,000 character limit.

|improve this answer|||||
  • 1
    Oh nice, awesome! I think this will work. What's the character limit to the formula on a field update? – Kenn K Feb 28 '14 at 21:48
  • I'm not sure, this site claims "The formula field for Field Updates has a much larger limit. There is actually no documentation on what the limit is.". – Phil Rymek Feb 28 '14 at 22:07
  • Current character limit on formula for workflow is 3900 – jaw999 Nov 18 '14 at 22:03

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.