I need to have two validation rules.
The first validation rule needs to prevent users from changing the status of an existing case in the "Development - Expert" queue from Closed to anything other than closed. Basically, once its closed in this queue, it should stay closed. This is what I have:
NOT(
AND(
Owner:Queue.QueueName = "Development - Expert",
ISCHANGED( Status ),
ISPICKVAL( Status , "Closed")
)
)
The second one needs to prevent users from changing the Case Owner to the "Development - Expert" queue for cases. This is what I have at the moment:
AND(
ISCHANGED( Case_Owner_ID__c ),
Case_Owner_ID__c = "3D00GC0000001v7rf"
)
However, it is using the first validation rule as the error when I change the case owner to "Development - Expert", and I can't even get the second error to show up. What changes do I need to make to get these validation rules to work properly?
Thank you!
3 answers
Hello Jordan,
Hope that your day is off to an amazing start. There's a problem with the Id in your second rule (has 17 digits instead of 18 or 15). Please try the below validation rule and report how it worked for you. Hope this helps and have a blessed day.Rule 1:
AND(
Owner:Queue.QueueName = "Development - Expert",
ISCHANGED( Status ),
ISPICKVAL(PRIORVALUE
(Status),
"Closed")
)
Best Regards,
Anthony McDougald
