function readOnly(count){ }
Sign Up ›
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
Learn More

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
Shannon.ax1730Shannon.ax1730 

Formula Help for SLA Flag

I have a formula that calculates Case SLA flag,

 

IF( SLA_Percentage_Close__c > 1.00, 
IMAGE("/servlet/servlet.FileDownload?file=01580000001FCiM", "MISSED - OVER 100% OF SLA", 20, 20), 

IF( SLA_Percentage_Close__c > 0.90, 
IF( ISPICKVAL(Type,"Rush Order"),IMAGE("/servlet/servlet.FileDownload?file=01580000001FQsa","Over 90% of SLA", 20, 20), 
IMAGE("/img/samples/flag_red.gif", "URGENT - OVER 90% OF SLA", 20, 20)), 

IF( SLA_Percentage_Close__c > 0.80, 
IF( ISPICKVAL(Type,"Rush Order"),IMAGE("/servlet/servlet.FileDownload?file=01580000001FQsa","Over 80% of SLA", 20, 20), 
IMAGE("/img/samples/flag_yellow.gif", "IN DANGER - Over 80% of SLA", 20, 20)), 

IF( ISPICKVAL(Type,"Rush Order"),IMAGE("/servlet/servlet.FileDownload?file=01580000001FQsa","Less than 80% of SLA", 20, 20),IMAGE("/img/samples/flag_green.gif", "Less than 80% of SLA", 20, 20) 
))))

 

I need to add another pickval type, but when I run it, I get the "Exceeds number of characters" error.

 

How can I add this type without the error?

 

Thanks in advance for your help!

 

Shannon

Vinita_SFDCVinita_SFDC

Hello Shannon,

 

Please refer first point in the below link to overcome this error:

 

https://help.salesforce.com/apex/HTViewSolution?urlname=Formula-field-exceeds-maximum-number-of-characters-1327109401516&language=en_US