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
Anwar Husain 6Anwar Husain 6 

Error on Trailhead Challenge: Create a formula field that returns an image to indicate data quality.

I keep getting this error : Challenge Not yet complete... here's what's wrong:  
The Lead object does not display the formula fields correctly. Tip: check the requirements again and make sure you have the correctly forumlas and their values.

Even through Formulas validate and the functionality works as expected, anyone else ran into this?
 
Best Answer chosen by Anwar Husain 6
Amit Chaudhary 8Amit Chaudhary 8
Please check below post for solution
1) https://developer.salesforce.com/forums/?id=906F0000000MIzjIAG
2) https://developer.salesforce.com/forums/?id=906F0000000MJ5SIAW


Lead Quality Helper::
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)

Lead Quality
IMAGE( 
CASE( Lead_Quality_Helper__c , 
1, "/img/samples/stars_100.gif ", 
2, "/img/samples/stars_200.gif", 
3, "/img/samples/stars_300.gif", 
4, "/img/samples/stars_400.gif", 
5, "/img/samples/stars_500.gif", 
"/img/samples/stars_000.gif"), 
"0 stars")

.....................
or 
CASE(Lead_Quality_Helper__c,
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"),
IMAGE("/img/samples/stars_000.gif", "0 stars"))


Please let us know if this will help you

Thanks
Amit Chaudhary
 

All Answers

Shashikant SharmaShashikant Sharma
Hi,

Check these:
  1. Make sure your formual is being created as per requirements. 
  2. Its showing appropriate image
  3. Field Level Security is appropriate ot show the field on Page Layout
  4. Position of Field on Page Layout is correct.
Let me know if you still can not find solution.

Thanks
Shashikant

 
Amit Chaudhary 8Amit Chaudhary 8
Please check below post for solution
1) https://developer.salesforce.com/forums/?id=906F0000000MIzjIAG
2) https://developer.salesforce.com/forums/?id=906F0000000MJ5SIAW


Lead Quality Helper::
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)

Lead Quality
IMAGE( 
CASE( Lead_Quality_Helper__c , 
1, "/img/samples/stars_100.gif ", 
2, "/img/samples/stars_200.gif", 
3, "/img/samples/stars_300.gif", 
4, "/img/samples/stars_400.gif", 
5, "/img/samples/stars_500.gif", 
"/img/samples/stars_000.gif"), 
"0 stars")

.....................
or 
CASE(Lead_Quality_Helper__c,
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"),
IMAGE("/img/samples/stars_000.gif", "0 stars"))


Please let us know if this will help you

Thanks
Amit Chaudhary
 
This was selected as the best answer
Anwar Husain 6Anwar Husain 6
Thanks a lot guys!! the problem was I had "None" as the value instead of "" (balnks)

IF (ISPICKVAL( Industry, "None"), 0, 1); I realized this after I removed all values except one and I was still seeing two stars.

Thanks for your assistance.
Anwar
Peter Nielsen 8Peter Nielsen 8
You might not be able to complete the challenge if you made your helper formula a hidden field when you first created it even though the formula works well as a hidden field, it is just that Trailhead cannot check it if it is hidden
Rebecca Heald 7Rebecca Heald 7
Hello,

I am having similar problems. I have set up the formula different ways and still get the same result. The Trailhead gives me the error (this is a direct copy and paste - not my spelling error):

"Challenge Not yet complete... here's what's wrong:
The Lead object does not display the formula fields correctly. Tip: check the requirements again and make sure you have the correctly forumlas and their values."

I have tried the best answer way of entering the formula above as well and still get the same error.

I have tried different combinations on the lead page layout incase it was something there... no joy.

Any tips please!

 
Itay ShechterItay Shechter

Thank you!
It's solve the 
"Challenge Not yet complete... here's what's wrong:
The Lead object does not display the formula fields correctly. Tip: check the requirements again and make sure you have the correctly forumlas and their values."
Error