• Tómas Guðmundsson
  • NEWBIE
  • 10 Points
  • Member since 2022

  • Chatter
    Feed
  • 0
    Best Answers
  • 0
    Likes Received
  • 0
    Likes Given
  • 1
    Questions
  • 2
    Replies
I have tried so many variations, both before and after I saw this thread: Using Basic Logic in Checkbox Formulas (https://developer.salesforce.com/forums/?id=906F0000000MIOYIA4)

After testing it out myself I can:
  • Create an opportunity without a close date and stage is not closed
  • Create an opportunity with a close date and stage is not closed
    • Whenever
  • Create an opportunity with a close date and stage is closed
    • Only in the future
This is the formula I have settled on:
AND(NOT(IsClosed), CloseDate < TODAY())
Please, someone tell me I am doing this wrong, and then how I should do it correctly, or that someone can fix this Hands-On Challenge: https://trailhead.salesforce.com/en/content/learn/modules/advanced_formulas/checkbox_logic_formulas
I have tried so many variations, both before and after I saw this thread: Using Basic Logic in Checkbox Formulas (https://developer.salesforce.com/forums/?id=906F0000000MIOYIA4)

After testing it out myself I can:
  • Create an opportunity without a close date and stage is not closed
  • Create an opportunity with a close date and stage is not closed
    • Whenever
  • Create an opportunity with a close date and stage is closed
    • Only in the future
This is the formula I have settled on:
AND(NOT(IsClosed), CloseDate < TODAY())
Please, someone tell me I am doing this wrong, and then how I should do it correctly, or that someone can fix this Hands-On Challenge: https://trailhead.salesforce.com/en/content/learn/modules/advanced_formulas/checkbox_logic_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?