You need to sign in to do that
Don't have an account?
Synthia Beauvais
Error: Compiled formula is too big to execute
I am getting Error: Compiled formula is too big to execute (6,166 characters). Maximum size is 5,000 characters for the formula below. How can I correct this?
IF( RecordTypeId='012700000009OvZAAU', IF( Data_Quality_Score__c =5,"All Contact Details Captured", "Missing: "& IF( ISBLANK( Name), "Account Name, ","")&""& IF( ISPICKVAL(Account_Vertical__c,""), "Account Vertical,","")&""& IF( ISBLANK( BillingStreet), "Street, ","")&""& IF( ISBLANK( BillingCity), "City, ","")&""& IF( ISBLANK( BillingState), "State, ","")&""& IF( ISBLANK( BillingPostalCode), "Postal Code, ","")&""& IF( ISBLANK( BillingCountry), "Country, ","")&""& IF( ISBLANK( NumberOfEmployees ), "Number Of Employees, ","")&""& IF( ISBLANK( DunsNumber), "Duns Number, ","")&""& IF( ISPICKVAL( Preferred_Language__c,""), " Preferred Language,","")&""& IF( ISPICKVAL( Segment_2__c,""), "Segment,","")), IF(RecordTypeId='012700000009OvoAAE' , IF( Data_Quality_Score__c =5,"All Contact Details Captured", "Missing: "& IF( ISBLANK( Name), "Account Name, ","")&""& IF( ISPICKVAL(Account_Vertical__c,""), "Account Vertical,","")&""& IF( ISBLANK( BillingStreet), "Street, ","")&""& IF( ISBLANK( BillingCity), "City, ","")&""& IF( ISBLANK( BillingState), "State, ","")&""& IF( ISBLANK( BillingPostalCode), "Postal Code, ","")&""& IF( ISBLANK( BillingCountry), "Country, ","")&""& IF( ISBLANK( NumberOfEmployees ), "Number Of Employees, ","")&""& IF( ISBLANK( DunsNumber), "Duns Number, ","")&""& IF( ISPICKVAL( Preferred_Language__c,""), " Preferred Language,","")&""& IF( ISPICKVAL( Segment_2__c,""), "Segment,","")&""& IF( ISBLANK( NaicsCode ), "NAICS Code, ","")&""& IF( ISBLANK( Servicing_Division__c), "Servicing Division, ","")),""))
That way, you are looking for the record type name instead of id. Its a bit more reliable and it is easier to read.
All Answers
Kind Regards,
Krishna.
Try removing the spaces between the brackets and the field API Name or a;so remove any space after the end of line.
Hope it helps.
Regards
Hope that helps
I am getting "Error: Incorrect number of parameters for function 'IF()'. Expected 3, received 4" with your formula. Any thoughts?
That should compile. Let me know if it doesn't
Data Quality Score
Data Quality Score Description
That way, you are looking for the record type name instead of id. Its a bit more reliable and it is easier to read.