Sign Up ›
  • Turan Fedai
  • NEWBIE
  • 0 Points
  • Member since 2023
  • Chatter
    Feed
  • 0
    Best Answers
  • 0
    Likes Received
  • 0
    Likes Given
  • 0
    Questions
  • 2
    Replies
SOLVED
11 replies

Level Up with Advanced Formulas

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!

 
SOLVED
21 replies

Using Basic Logic in Checkbox Formulas

Admin Advanced >  Advanced Formulas > Using Basic Logic in Checkbox Formulas

The formula I used is: 
NOT(IsClosed) && (CloseDate <= (Today() - 1))
Also tried: 
AND(NOT(IsClosed),(CloseDate <= (Today() - 1)))

The error code I get is:

"Hey McFly, unless you are planning to go back in time, please update your close date"

Trialhead is giving the error:
Challenge Not yet complete... here's what's wrong: 
The validation rule does not reference the 'IsClosed' and 'CloseDate' fields correctly. Take a look at the requirements again.

When I test it out myself, it's working as expected. Any ideas on what it could be?