function readOnly(count){ }
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
+ Start a Discussion
cchangcchang 

How to work around the formula size limit?

At regular formula field, the compile size is 5000 characters. My formula is much more.

So I switched to workflow update field to update a text field using formula. The size limit there is 3900 characters. (even less)

People are saying 2) should have no size limit documented. Do I do anything wrong?

 

Can anyone please reply how to work around the formula size limit?

Andy BoettcherAndy Boettcher

Your best bet is to split your calculation up across a number of fields.

 

<set 1> = result 1

<set 2 accounting for result 1> = result 2

<set 3 accounting for result 2> = result 3

<set 4 accounting for result 3> = final result

 

-Andy