• Ankush kumar 23
  • 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!

 
Working on trailhead challenge.  Trying nested if statement in formula  basically > or equal to 25=early   between 25 and 75 =middle  >75 late
here is my formula  keep getting error

IF( Percent_Complete__c  <= 25), "Early",
 IF( AND ( Percent_Complete__c >25, Percent_Complete__c  <= 75),"Middle",
 IF( Percent_Complete__c >75,"Late")))