• Devon Plopper
  • NEWBIE
  • 0 Points
  • Member since 2020

  • Chatter
    Feed
  • 0
    Best Answers
  • 0
    Likes Received
  • 0
    Likes Given
  • 0
    Questions
  • 2
    Replies
Hello, 

My trailhead wont let be beat this challenge. I says:

"Challenge Not yet complete... here's what's wrong: 
The 'Opportunity_Progress__c' formula field does not exist or is not of type 'Number'"

Heres my code:

IF( Percent_Completed__c <=  0.25, "Early", IF( Percent_Completed__c  <= 0.75, "Middle", "Late" ) )

(TODAY() -DATEVALUE(CreatedDate))/ (CloseDate-DATEVALUE(CreatedDate))

What am I doing wrong? The top formula outputs as text, bottom one is a percent

Thank you for help!

 
Hello All,
I have completed this challenge.

1-For this first you need to create a helper formula field(type-percent) 
Percent Completed :
(DATEVALUE( CreatedDate ) - CloseDate )/100


2- Then you need to create the actual formula field (type- text) by using the helper formula field.
Opportunity Progress :

IF( Percent_Completed__c <=25,"Early", 
IF(Percent_Completed__c <=75,"Middle", 
"Late"))

Thanks,
Nida