+ Start a Discussion
GRStevenBrookesGRStevenBrookes 

Formula to big to execute!

Hate it when this happens!!

 

Any ideas on how I can reduce Compiled Size is 5,960 - so only a little bit over!

 

IF(
AND(
Account_Manager_Assigned__c ="OK",
Accounts_Approval__c ="OK",
Final_Client_Approval__c ="OK",
Initial_Client_Approval__c ="OK",
QAT_Approval__c  ="OK",
QAT_Approval__c  ="OK",
Sales_Handover_Completed__c  ="OK",
Script_Build_Complete__c  ="OK",
Scriptor_Allocated__c  ="OK",
SID_Received__c  ="OK",
Skill_Level_Assigned__c  ="OK",
Trainer_Assigned__c  ="OK",
Training_Completed__c  ="OK",
UAT_Approval__c  ="OK",
Welcome_Call_Completed__c  ="OK"),
IMAGE("/img/msg_icons/confirm16.png","OK"),
IMAGE("/img/msg_icons/error16.png","Stop"))

 

Best Answer chosen by Admin (Salesforce Developers) 
SteveMo__cSteveMo__c

Ouch!  that's where your overflow is coming from.  It's the SUM of ALL the formulas used in the formula fields in your formula.

All Answers

SteveMo__cSteveMo__c

That formula doesn't look very big, are any of the fields being referenced Formula fields?  If so, what is their underlying code?  

 

If you are on EE or UE you might want to try using a WFR and a Field Update instead.

GRStevenBrookesGRStevenBrookes

Hi,

 

They are all forumla fields which effectivly check conditions elsewhere on the record and display an image based on that condition.

SteveMo__cSteveMo__c

Ouch!  that's where your overflow is coming from.  It's the SUM of ALL the formulas used in the formula fields in your formula.

This was selected as the best answer
GRStevenBrookesGRStevenBrookes

Ok - Ill have to work out a way around this - possibly with validation!

 

Thanks for your advice any how!

jjvdevjjvdev

Curious about the workaround you ended up using.