function readOnly(count){ }
Sign Up ›
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
Learn More

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
Crystal M. ReganCrystal M. Regan 

Too many characters in field formula.

The following field formula says the syntax is correct, but the character limit is 5013, with a max at 5000. Any suggestions on how to truncate this formula would be appreciated.

IF
(     AND(ISPICKVAL(Status, "Not Contacted"),  Days_in_Current_Status__c   > 2),"Past Due",
    IF( AND(ISPICKVAL(Status, "Contacted, but not reached"),  Days_Since_Last_Activity__c    > 10 ) ,"Past Due",
    IF( AND(ISPICKVAL(Status, "Contacted, reached, follow up needed"), Days_Since_Last_Activity__c    > 7) ,"Past Due",
        IF( AND(ISPICKVAL(Status, "Qualified"), Days_Since_Last_Activity__c    > 30),"Past Due",
    IF( AND(ISPICKVAL(Status, "Keeping Warm"), Days_Since_Last_Activity__c    > 30),"Past Due",
    IF( AND(ISPICKVAL(Status, "Attempting to Contact"), Days_in_Current_Status__c   > 2),"Past Due",
    IF( AND(ISPICKVAL(Status, "Contacted"), Days_Since_Last_Activity__c    > 7 ) ,"Past Due",
    IF( AND(ISPICKVAL(Status, "Nurturing"), Days_Since_Last_Activity__c    > 183 ) ,"Past Due",
    IF( AND( Days_Since_Last_Activity__c    = NULL ) ,"Past Due",
    IF( ISPICKVAL(Status, "Converted"),"Converted",
    IF( ISPICKVAL(Status, "Dead") , "Dead", "Open"))))))))))
)
VinayVinay (Salesforce Developers) 
If you are hitting this limit try to smaller character limit can be remedied by splitting the formula into 2 fields. Create another formula field and break out some part of the code into that one. Then call Formula_A within Formula_B. 

Check below references.
https://help.salesforce.com/articleView?id=000324937&type=1&mode=1
https://salesforce.stackexchange.com/questions/41643/formula-field-is-too-big-to-execute-5-480-characters

Hope above information was helpful.

Please mark as Best Answer so that it can help others in the future.

Thanks,
Zachary SingerZachary Singer
Instead of nesting so many IF() statements with the same result of "Past Due", use the OR() function to evaluate them all. You can keep the last 2 IF() statements since they have different results. Also remove any unnecessary parentheses and AND() statements. Here is a cleaned up version:

IF(     
OR(
AND(ISPICKVAL(Status, "Not Contacted"),  Days_in_Current_Status__c   > 2),
AND(ISPICKVAL(Status, "Contacted, but not reached"),  Days_in_Current_Status__c    > 10 ),
AND(ISPICKVAL(Status, "Contacted, reached, follow up needed"), Days_in_Current_Status__c    > 7),
AND(ISPICKVAL(Status, "Qualified"), Days_in_Current_Status__c    > 30),
AND(ISPICKVAL(Status, "Keeping Warm"), Days_in_Current_Status__c    > 30),
AND(ISPICKVAL(Status, "Attempting to Contact"), Days_in_Current_Status__c   > 2),
AND(ISPICKVAL(Status, "Contacted"), Days_in_Current_Status__c    > 7 ) ,
AND(ISPICKVAL(Status, "Nurturing"), Days_in_Current_Status__c    > 183 ) ,
Days_in_Current_Status__c    = NULL), "Past Due",
IF( ISPICKVAL(Status, "Converted"),"Converted",
IF( ISPICKVAL(Status, "Dead") , "Dead", "Open")))
Crystal M. ReganCrystal M. Regan
Thank you, this helped point me in the right direction! I made slight changes due to different fields needed for the criteria (sometimes days in status, other times days since last activity) and was able to get the desired results. Please see below: IF( OR( AND(ISPICKVAL(Status, "Not Contacted"), Days_in_Current_Status__c > 2), AND(ISPICKVAL(Status, "Contacted, but not reached"), Days_Since_Last_Activity__c > 10 ), AND(ISPICKVAL(Status, "Contacted, reached, follow up needed"), Days_Since_Last_Activity__c > 7), AND(ISPICKVAL(Status, "Qualified"), Days_Since_Last_Activity__c > 30), AND(ISPICKVAL(Status, "Keeping Warm"), Days_Since_Last_Activity__c > 30), AND(ISPICKVAL(Status, "Attempting to Contact"), Days_in_Current_Status__c > 2), AND(ISPICKVAL(Status, "Contacted"), Days_Since_Last_Activity__c > 7 ) , AND(ISPICKVAL(Status, "Nurturing"), Days_Since_Last_Activity__c > 183 ) , ISNULL(Days_Since_Last_Activity__c ) ), "Past Due", IF( ISPICKVAL(Status, "Converted"),"Converted", IF( ISPICKVAL(Status, "Dead") , "Dead", "Open")))
Rachael HirtheRachael Hirthe
The code in a Formula Field can exceed the maximum number of characters allowed in two ways: Directly in the Formula Field's characters (3900). In the overall size of the Formula after other included Formula Fields are factored.

https://www.jcpenneykiosk.us/