Formula field exceeds maximum number of characters

This article explains how formula fields in Salesforce can exceed character limits (3,900 characters directly, or 5,000 bytes when other formula fields are included) and provides several workarounds.

What to Do if Hitting This Limit

1. Split the formula into two fields to resolve the smaller character limit (3,900). Create another formula field and move some portion of the code into it. Then call Formula_A within Formula_B. Each formula field can have up to 3,900 characters.
2. Reduce the overall formula chain size. When a formula field refers to other formula fields (which may in turn refer to even more formula fields), the compounded code can exceed the 5,000-byte limit. Review the whole combination of formula fields to find anything that can be reduced or eliminated from the chain. Even a small reduction can have a ripple effect and significantly reduce overall size.
3. Use Workflow (Enterprise Edition or Unlimited Edition only) to help work around the limit:
   1. Create a new hidden field not visible on any page layout.
   2. Create a new Workflow Rule that triggers when a record is Created or Edited, with a criteria that is always true (for example: Owner Name not equal to NULL).
   3. Create an Immediate Workflow Action that performs a Field Update to the newly created hidden field.
   4. Click Use a formula to set new value and enter the name of the first formula field (Formula_A). Whenever a record is created or edited, Formula_A's results will be calculated and copied into this new regular field. Then reference this field instead of Formula_A within Formula_B.
   5. Note: You must manually update existing records for the updated values to be applied.
4. Use Apex code (Enterprise Edition or Unlimited Edition) to trigger an update to a field on the record. This provides more powerful and flexible options, including the ability to assign values based on procedural algorithms (for example, a double-declining balance) and to reference values beyond the record or object being evaluated in a formula or workflow, similar to the VLOOKUP() function that can be used in a validation rule but not in a custom formula field.
5. Use the CONTAINS function where possible. For example, when comparing multiple picklist values, use CONTAINS(AB:AC:AD:AE) based on the requirement.

Best Practice

For best results when referencing multi-level nested formula fields, split the overall code approximately in half near the middle of the formula field chain. This reduces the formula size to fit within character limits. Also, do not include Roll-Up

Please see the Tips for reducing formula size.

Please see Formula Field Limits and Restrictions and Process Formula Limitations for other information.