You need to sign in to do that
Don't have an account?
cchang
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?
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