There is a limit of 1000 characters per custom formula, including spaces and carriage returns. However, because you can reference other formulas within formulas, you can sometimes divide up big formulas into multiple fields to get around this limit.

There are other limits that are related to the size of the database query generated by the system. You may run into these limits if you create custom formulas that reference other custom formulas. If this happens, you will get a syntax validation error stating, “formula too large to execute.”