function readOnly(count){ }
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
+ Start a Discussion
SFDC Admin & AnalystSFDC Admin & Analyst 

Formula Field exceeding 5000 characters

Hi

 

My formula is exceeding 5000 characters while compiling.

 

Here is the formula

 

________________________________________________________________________________________

 

 

IF(US_Account_Manager__c != null,If(EU_Account_Manager__c != null,If(US_Relationship_Manager__c != null,If(EU_Relationship_Manager__c != null,

1234

,

123

),If(EU_Relationship_Manager__c != null,

124

,

12

)),

If(US_Relationship_Manager__c != null,If(EU_Relationship_Manager__c != null,

134

,

13

),If(EU_Relationship_Manager__c != null,

14

,

1

)))

,If(EU_Account_Manager__c != null,If(US_Relationship_Manager__c != null,If(EU_Relationship_Manager__c != null,

234

,

23

),If(EU_Relationship_Manager__c != null,

24

,

2

)),If(US_Relationship_Manager__c != null,If(EU_Relationship_Manager__c != null,

34

,

3

),If(EU_Relationship_Manager__c != null,

4

,

''

))))

 

----------------------------------------------------------------------------

A1 = US_Account_Manager__c != null

A2 = EU_Account_Manager__c != null

A3 = US_Relationship_Manager__c != null

A4 = EU_Relationship_Manager__c != null

-------------------------------------------------------------------------------------

1 = US_Account_Manager__r.FirstName + US_Account_Manager__r.LastName  + ' ' + '(US CSM)'+' '+','+' '+

2 = EU_Account_Manager__r.FirstName + EU_Account_Manager__r.LastName + ' ' + '(EU CSM)'+' '+' ,'+' '+

3 = US_Relationship_Manager__r.FirstName + US_Relationship_Manager__r.LastName + ' ' + '(US RM)'+' '+','+' '+

4 = EU_Relationship_Manager__r.FirstName + EU_Relationship_Manager__r.LastName + ' ' + '(EU RM)'

 

_________________________________________________________________________________________

Best Answer chosen by Admin (Salesforce Developers) 
SFDC Admin & AnalystSFDC Admin & Analyst

split the formula in three formulas.

 

access the first two formulas in the third formula.

 

All Answers

SFDC Admin & AnalystSFDC Admin & Analyst

split the formula in three formulas.

 

access the first two formulas in the third formula.

 

This was selected as the best answer