Building formula text and compiled character size limits

There is a text character and byte size limit of 3,900 characters and a limit of 5,000 characters for the compiled characters for formulas.

When this limit is reached, you will be unable to save the formula field and will be presented with the following error:

Compiled formula is too big to execute (7,085 characters). Maximum size is 5,000 characters.

It is common to encounter these limits when building complicated formula field calculations, particularly when building formulas that reference other formula fields. While there is no way to increase this limit, there are some methods to help avoid and work around these limitations; they are listed as follows:

• Use the CASE function for branch conditions

• Use algebra

For formulas that use multiple branch conditions to derive the values, as in the preceding example formula, check whether the market is US and the state is California, Nevada, or Utah. You can replace the nested IF statements and...