+ Start a Discussion
jprichterjprichter 

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?
Best Answer chosen by jprichter
Jeff DouglasJeff Douglas
Everyone, give it a try now. We just pushed a fix so that should do the trick.

Jeff Douglas
Trailhead Developer Advocate

All Answers

pconpcon
Strangely enough, I'm unable to get this to work as expected.  I've reached out to some contacts on the Trailhead team to see if the challenge is worded correctly.
Chris DuarteChris Duarte
We're looking at it. Thanks for letting us know. Will get back to you soon!
Tolga SunarTolga Sunar
Hello,

I'm stuck on this part as well. Recreated the formula many times, did tests on Opportunity records, but no success. I feel sorry for my wasted time on trying to fix something which is apparently a bug.

Please fix this.
merrick devillemerrick deville
I am having the same issue as well
 
Chris DuarteChris Duarte
We are working on a fix today. I will let you know once it is live. I apologize for the inconvenience.
Jeff DouglasJeff Douglas
Everyone, give it a try now. We just pushed a fix so that should do the trick.

Jeff Douglas
Trailhead Developer Advocate
This was selected as the best answer
merrick devillemerrick deville
Passed thank you
!
James LoghryJames Loghry
I jsut got this workin as well.
Chris DuarteChris Duarte
Jeff Douglas FTW
Ryan William SchorrRyan William Schorr
Thanks for the fix! Apparently I did it right because when I checked again it worked.
Tolga SunarTolga Sunar
Thanks for the quick fix. Logged in, checked the challenge and passed it!
salesforcehiresalesforcehire

Today is 06 December 2016 and I am trying to complete this. I have tried several different ways to complete this and even looked on here at some of your examples and am gettign the same error regardless. Someone help please?

"There was an unhandled exception. Please reference ID: (Random 8 Character Code each time). Error: ArgumentError. Message: bad argument (expected URI object or URI string)"

Thank you in advance!

salesforcehiresalesforcehire
UpDate on above... when you get that error I was getting just log out and log back in and recheck the challenge. For some reason I only enctouner it on Validation Rules so far, lol.
Ryan William SchorrRyan William Schorr
Salesforcehire: It looks like you're getting a pretty fundamental error with the platform that may be extremely difficult to troubleshoot. As annoying as it may be, the easiest solution is to create a new dev org (https://developer.salesforce.com/signup (https://developer.salesforce.com/signup" target="_blank)), link it to your Trailhead account, and attempt the unit again. You should not need to complete any prior units to complete this challenge. Good luck!