You need to sign in to do that
Don't have an account?
Mark Tough 01
Trailhead - Advanced Admin Formulas
Hate to ask but has anyone has luck with Advanced Admin - picklist formulas module. I've checked on all the naming conventions and added to Page Layout SO expect it's the formula which I've added below. It's either obvious or I've totally got the wrong end of the formula stick (which is possible)! Any help or direction appreciated.
if(ISPICKVAL(Status, "Escalated") && NOT (ISPICKVAL(Priority, "High")) && NOT(ISPICKVAL(PRIORVALUE(Status), "Closed")) && ISPICKVAL(Status, "closed") ,True,false)
if(ISPICKVAL(Status, "Escalated") && NOT (ISPICKVAL(Priority, "High")) && NOT(ISPICKVAL(PRIORVALUE(Status), "Closed")) && ISPICKVAL(Status, "closed") ,True,false)
Try this below formula in your validation rule...
IsEscalated=TRUE &&
(NOT(ISPICKVAL(Priority, "High"))) ||
(ISPICKVAL (Status, "Closed")) ||
(IsClosedOnCreate=True)
You will surely tackle this trail by using the above formula...
Please let me know if you need any help.
Correct means mark this as a best answer
Thanks,
Raj
(Sweet Potato Tec)
All Answers
Try this below formula in your validation rule...
IsEscalated=TRUE &&
(NOT(ISPICKVAL(Priority, "High"))) ||
(ISPICKVAL (Status, "Closed")) ||
(IsClosedOnCreate=True)
You will surely tackle this trail by using the above formula...
Please let me know if you need any help.
Correct means mark this as a best answer
Thanks,
Raj
(Sweet Potato Tec)
It took me a while to double back on this, it worked no problem and you've taught a much better structure to do this - Thanks again.
Mark