In the below validation rule. I need this to fire both when the record is new and since the record is assigned to the Queue only after being committed to the system, I will also need it to fire on the Queue Owner. So the OR condition is New() or Owner:Queue.DeveloperName = "RecordTypeDevName" - However, the below is not working for me. Please assist.
AND(
OR(
ISNEW(),
Owner:Queue.DeveloperName='QueueDevName'),
ISCHANGED( Status ),
$RecordType.DeveloperName ='RecordTypeDevName',
NOT(CONTAINS($Profile.Name, "A")),
$User.LastName != "B",
$Profile.Name != "C",
$Profile.Name != "D"
)
Any help is greatly appreciated!
Ah, so I think I see the issue.
You have ISCHANGED(Status) in your AND criteria. When a record is new this will always be false because nothing has changed. You'll need to rejig the formula so that you don't need both ISNEW() and ISCHANGED(Status) to be true because this can never be the case.
