You need to sign in to do that
Don't have an account?
sfdc@isha.ax1814
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
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
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)
Thanks for the reply.
even for above solution also iam getting the same error.Find below screenshot.
Any suggestions please.
Regards,
Isha