function readOnly(count){ }
Sign Up ›
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
Learn More

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
Mark Tough 01Mark 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.

User-added image

if(ISPICKVAL(Status, "Escalated") && NOT (ISPICKVAL(Priority, "High")) && NOT(ISPICKVAL(PRIORVALUE(Status), "Closed")) &&   ISPICKVAL(Status, "closed") ,True,false)
Best Answer chosen by Mark Tough 01
Maharajan CMaharajan C
Hi Mark,

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

Maharajan CMaharajan C
Hi Mark,

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)

 
This was selected as the best answer
Mark Tough 01Mark Tough 01
Thanks Raj,

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