You need to sign in to do that
Don't have an account?
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)'
_________________________________________________________________________________________
split the formula in three formulas.
access the first two formulas in the third formula.
All Answers
Hello,
Please refer the following link to optmize your folmula:
https://help.salesforce.com/apex/HTViewSolution?urlname=Formula-field-exceeds-maximum-number-of-characters-1327109401516&language=en_US
split the formula in three formulas.
access the first two formulas in the third formula.