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 answers
  1. Mar 8, 2022, 3:56 PM

    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