+ Start a Discussion
sfdc@isha.ax1814sfdc@isha.ax1814 

Compiled formula is too big to execute (6,846 characters). Maximum size is 5,000 characters-Error pls help


Hi,

I have below formuls.Getting the below error that "Compiled formula is too big to execute (6,846 characters). Maximum size is 5,000 characters".

Can you please help on this?

IF (OR ((Initial_Engagement_Date__c>Contract_Provided_Date__c),
          (Initial_Engagement_Date__c>Contract_Signed_Date__c),
          (Initial_Engagement_Date__c>Latest_Implementation_Date__c),
          (Initial_Engagement_Date__c>Go_Live_Date__c)),"Engaged",          
IF(OR ((Contract_Provided_Date__c>= Initial_Engagement_Date__c),
          (Contract_Provided_Date__c>Contract_Signed_Date__c),
          (Contract_Provided_Date__c>Latest_Implementation_Date__c),
          (Contract_Provided_Date__c>Go_Live_Date__c)),"Contract Provided",                    
IF(OR ((Contract_Signed_Date__c>= Initial_Engagement_Date__c),
          (Contract_Signed_Date__c>=Contract_Provided_Date__c),
          (Contract_Signed_Date__c>Latest_Implementation_Date__c),
          (Contract_Signed_Date__c>Go_Live_Date__c)),"Contract Signed",
IF(OR ((Latest_Implementation_Date__c>= Initial_Engagement_Date__c),
          (Latest_Implementation_Date__c>=Contract_Provided_Date__c),
         (Latest_Implementation_Date__c>= Contract_Signed_Date__c),
          (Latest_Implementation_Date__c>Go_Live_Date__c)),"Implementation",
IF(OR ((Go_Live_Date__c>= Initial_Engagement_Date__c),
          (Go_Live_Date__c>=Contract_Provided_Date__c),
          (Go_Live_Date__c>=Latest_Implementation_Date__c)), "Live",
IF(ISPICKVAL(CL360_Status__c, "Declined"), "Declined",NULL))))))



Regards,
Isha
Nayana KNayana K
May be you need to create 2 formula fieds :
One proxy formula field say proxyFormula__c :

IF (OR (Initial_Engagement_Date__c>Contract_Provided_Date__c,
          Initial_Engagement_Date__c>Contract_Signed_Date__c,
          Initial_Engagement_Date__c>Latest_Implementation_Date__c,
          Initial_Engagement_Date__c>Go_Live_Date__c),"Engaged",          
IF(OR (Contract_Provided_Date__c>= Initial_Engagement_Date__c,
          Contract_Provided_Date__c>Contract_Signed_Date__c,
          Contract_Provided_Date__c>Latest_Implementation_Date__c,
          Contract_Provided_Date__c>Go_Live_Date__c),"Contract Provided",                    
IF(OR (Contract_Signed_Date__c>= Initial_Engagement_Date__c,
          Contract_Signed_Date__c>=Contract_Provided_Date__c,
          Contract_Signed_Date__c>Latest_Implementation_Date__c,
          Contract_Signed_Date__c>Go_Live_Date__c),"Contract Signed", NULL)))

Now replace the original forumla :

IF(proxyFormula__c = NULL,
IF(OR (Latest_Implementation_Date__c>= Initial_Engagement_Date__c,
          Latest_Implementation_Date__c>=Contract_Provided_Date__c,
         Latest_Implementation_Date__c>= Contract_Signed_Date__c,
          Latest_Implementation_Date__c>Go_Live_Date__c),"Implementation",
IF(OR (Go_Live_Date__c>= Initial_Engagement_Date__c,
          Go_Live_Date__c>=Contract_Provided_Date__c,
          Go_Live_Date__c>=Latest_Implementation_Date__c), "Live",
IF(ISPICKVAL(CL360_Status__c, "Declined"), "Declined",NULL))),proxyFormula__c)
sfdc@isha.ax1814sfdc@isha.ax1814
Hi,

Thanks for the reply.
User-added image
even for above solution also iam getting the same error.Find below screenshot.


Any suggestions please.



Regards,
Isha
 
Nayana KNayana K
I suggest you to go for process builder or workflow field update.