I've developed a formula that was functional for my Leads. The formula was giving which lead is cold,warm or hot.
Formula below:
CASE( Formula_SUM_ALL__c ,
-30, IMAGE("/servlet/servlet.FileDownload?file=01520000002XTrg", "COLD", 16,48),
-25, IMAGE("/servlet/servlet.FileDownload?file=01520000002XTrg", "COLD", 16,48),
-20, IMAGE("/servlet/servlet.FileDownload?file=01520000002XTrg", "COLD", 16,48),
-15, IMAGE("/servlet/servlet.FileDownload?file=01520000002XTrg", "COLD", 16,48),
-10, IMAGE("/servlet/servlet.FileDownload?file=01520000002XTrg", "COLD", 16,48),
-5, IMAGE("/servlet/servlet.FileDownload?file=01520000002XTrg", "COLD", 16,48),
0, IMAGE("/servlet/servlet.FileDownload?file=01520000002XTrg", "COLD", 16,48),
5, IMAGE("/servlet/servlet.FileDownload?file=01520000002XTrg", "COLD", 16,48),
10, IMAGE("/servlet/servlet.FileDownload?file=01520000002XTrg", "COLD", 16,48),
15, IMAGE("/servlet/servlet.FileDownload?file=01520000002XTrg", "COLD", 16,48),
20, IMAGE("/servlet/servlet.FileDownload?file=01520000002XTrg", "COLD", 16,48),
25, IMAGE("/servlet/servlet.FileDownload?file=01520000002XTrg", "COLD", 16,48),
30, IMAGE("/servlet/servlet.FileDownload?file=01520000002Y3F0", "WARM", 16,48),
35, IMAGE("/servlet/servlet.FileDownload?file=01520000002Y3F0", "WARM", 16,48),
40, IMAGE("/servlet/servlet.FileDownload?file=01520000002Y3F0", "WARM", 16,48),
45, IMAGE("/servlet/servlet.FileDownload?file=01520000002Y3F0", "WARM", 16,48),
50, IMAGE("/servlet/servlet.FileDownload?file=01520000002Y3F0", "WARM", 16,48),
55, IMAGE("/servlet/servlet.FileDownload?file=01520000002Y3F0", "WARM", 16,48),
60, IMAGE("/servlet/servlet.FileDownload?file=01520000002Y3F0", "WARM", 16,48),
65, IMAGE("/servlet/servlet.FileDownload?file=01520000002Y3F0", "WARM", 16,48),
70, IMAGE("/servlet/servlet.FileDownload?file=01520000002Y3FP", "HOT", 16,48),
75, IMAGE("/servlet/servlet.FileDownload?file=01520000002Y3FP", "HOT", 16,48),
80, IMAGE("/servlet/servlet.FileDownload?file=01520000002Y3FP", "HOT", 16,48),
85, IMAGE("/servlet/servlet.FileDownload?file=01520000002Y3FP", "HOT", 16,48),
90, IMAGE("/servlet/servlet.FileDownload?file=01520000002Y3FP", "HOT", 16,48),
95, IMAGE("/servlet/servlet.FileDownload?file=01520000002Y3FP", "HOT", 16,48),
100, IMAGE("/servlet/servlet.FileDownload?file=01520000002Y3FP", "HOT", 16,48),
null)
Before:
After new edits:
With Amit suggestion:
Now what i want is to make it smaller . Can I somehow go with the range of numbers? For example use case as well but not to exceed the compiling ?
Formula_SUM_ALL__c = Formula_Video__c + Formula_Monetization__c + Formula_OVP__c + Formula_Social_Media_Popularity__c + Formula_Status__c
Formula_Video__c = IF( ISPICKVAL( Has_Video_Type__c , "No") , 0, 25)
Formula_Monetization__c = IF (ISBLANK(Video_Monetizing_tool__c),
NULL,
IF(OR(INCLUDES(Video_Monetizing_tool__c,"No"), INCLUDES(Video_Monetizing_tool__c,"N/A")),
0,
10
)
)
Formula_OVP__c = CASE( OVP_used__c ,
"Brightcove", 10,
"Flow Player",10,
"Haivision",10,
"JW Player", 10,
"Kaltura",10,
"Piksel",10,
"Qbrick", 10,
"StreamUK",10,
"thePlatform",10,
"Vimeo",10,
"Vyoo",10,
"Youtube",10,
"N/A",0,
"None",0,
0)
Formula_Social_Media_Popularity__c = IF( Formula_SUM_Social__c > 0 && Formula_SUM_Social__c < 5000, 0,
IF( Formula_SUM_Social__c >= 5000 && Formula_SUM_Social__c < 10000 , 5,
IF( Formula_SUM_Social__c >= 10000, 10, null) ) )
Formula_SUM_Social__c = Facebook_Fans__c + Twitter_Fans__c + Linkedin_Followers__c
Formula_Status__c = CASE( Status ,
"None",0,
"Contacted/Campaign in Progress", 10,
"Not Responding", -30,
"Prospect in communication", 35,
"Not Interested", -30,
"Close to Converting",45,
"May Convert One Day",10
,null)
Best Answer
This might help, Compile size if far less(371):