Skip to main content
  1.  
  2. Admin Advanced

 

  1.  
  2. Advanced Formulas

 

  1.  
  2. Use Text Formulas

 I rightly completed the Lead quality helper, lead quality perfectly, i got the star rating in my exercise, but iam unable to get 500 points., to complete this challenge, anyone facing this issue, help me to get 500points

14 risposte
  1. 8 mar 2022, 15:56

    Hi Gayathri,

     

    In short, the IMAGE needs to be used inside of CASE:

     

    For the Lead Quality Helper to work:

    IF(ISBLANK(Email), 0, 1) + IF(ISBLANK(Phone), 0, 1) + IF(ISBLANK(Company), 0, 1) + IF(ISBLANK(Title), 0, 1) + IF(ISPICKVAL((Industry),""), 0 ,1)  For the Lead Quality to use the values correctly from the helper, the IMAGE needs to be inside the CASE instead of the example in the lecture: CASE(Lead_Quality_Helper__c, 0, IMAGE("/img/samples/stars_000.gif","0 stars"), 1, IMAGE("/img/samples/stars_100.gif", "1 star"), 2, IMAGE("/img/samples/stars_200.gif", "2 stars"), 3, IMAGE("/img/samples/stars_300.gif", "3 stars"), 4, IMAGE("/img/samples/stars_400.gif", "4 stars"), 5, IMAGE("/img/samples/stars_500.gif", "5 stars"), "Unknown")

     

    Hope this helps, this made my challenge to be verified and earn the 500pts.

     

    Regards,

    Rodrigo  

0/9000