You need to sign in to do that
Don't have an account?
Brandon_Bertrand
Trailhead: Using Formula Fields
Trying to do the above trailhead module (https://developer.salesforce.com/en/trailhead/point_click_business_logic/formula_fields#challenge)
I have a formula field returning text with the following formula:
IF( TODAY() > Brandon__SLAExpirationDate__c , 'true', 'false' )
I have tested it on an account and when the SLA Expiry date is in the past it shows true and when it is in the future it shows false.
When I check the challenge I get the following error
An account with an SLA date in the past returned an SLA expired of false (it should return true).
I have also tried with returning a checkbox.
Am I misunderstanding the requirements?
I have a formula field returning text with the following formula:
IF( TODAY() > Brandon__SLAExpirationDate__c , 'true', 'false' )
I have tested it on an account and when the SLA Expiry date is in the past it shows true and when it is in the future it shows false.
When I check the challenge I get the following error
An account with an SLA date in the past returned an SLA expired of false (it should return true).
I have also tried with returning a checkbox.
Am I misunderstanding the requirements?
Looks like Trailhead Training modules didn't like it that i change it to checkbox after i had created the formula field.
All Answers
2. Put formula as IF( TODAY() > Brandon__SLAExpirationDate__c , true, false)
[true / false are not as Text but should be as value]
PS: if this answers your question then hit Like and mark it as solution!
please confirm
this formula is working perfectly for Date type field.
I have tried that, and have put it back to that and the check is still failing.
Amul
Brandon__SLAExpirationDate__c is set as a Date type
Please mail me at amulhai@gmail.com
Looks like Trailhead Training modules didn't like it that i change it to checkbox after i had created the formula field.
Hi Guys,.. I too and having a challenge here.. as I keep getting the following error message:
Challenge not yetcomplete... here's what's wrong:
There was an unexpected error in your org which is preventing this assessment check from completing: System.DmlException: Insert failed. First exception on row 0; first error: FIELD_CUSTOM_VALIDATION_EXCEPTION, Return true if the SLA has expired, and false if it has not: []
I was able to incoporate the following formula ...."SLAExpirationDate__c < TODAY()" under my new "SLA Expired" account custom field
Question: Do in need to add an IF Statement formula under my "SLA Expiration Date" Account Custom Field as well?