Skip to main content
Topics#Salesforce DeveloperChris Allen 的问题
Chris Allen (Bestpass) 提问于 #Salesforce Developer
2022年8月2日 14:23

Formula field with Showing Flags ( Good, AT Risk, and Okay )

Good Morning,

I am trying to create a formula field "Total Health Score" where If the score is 1 - 4.75 = Good, 5 - 6.75 = okay and 7-10 = At Risk with colored Flags Red, Green and Yellow. I created the picklist field called "Total Customer Health Score" with At Risk, Good, and Okay. I am having trouble with if it is zero, then a green flag show. How would I either show a different flag or something else or not show anything if it is zero. Here is my formula I have now:

IF(

Total_Customer_Health_Score__c  <= 4.75 ,

IMAGE('/img/samples/flag_green.gif','Green Flag'),

IF(

Total_Customer_Health_Score__c  <= 6.75,

IMAGE('/img/samples/flag_yellow.gif','Yellow Flag'),

IF(

Total_Customer_Health_Score__c   >= 7,

IMAGE('/img/samples/flag_red.gif', 'Red Flag'),

IF(

Total_Customer_Health_Score__c = 0,

NULL, NULL))))
4 个回答
  1. Sai Praveen Kumar Kakkirala (Salesforce)
    2022年8月2日 14:37
    Hi Chris,

    Can you try the formula as below.

     

    IF(
    AND(Total_Customer_Health_Score__c  <= 4.75 , Total_Customer_Health_Score__c !=0),
    IMAGE('/img/samples/flag_green.gif','Green Flag'),
    IF(
    AND(Total_Customer_Health_Score__c  <= 6.75,Total_Customer_Health_Score__c >4.75) ,
    IMAGE('/img/samples/flag_yellow.gif','Yellow Flag'),
    IF(
    Total_Customer_Health_Score__c   >= 7,
    IMAGE('/img/samples/flag_red.gif', 'Red Flag'),
     NULL)))

    Let me know if you face any syntax issues .

    If this solution helps, Please mark it as best answer.

    Thanks,
撰写回答...
0/9000