My Validation Rule checks out ok but via testing it's not working. I logged in as Colette, a member of the Audit team, and my rule is stopping her from making edits when SHE should be allowed. Please help. Many thanks!
Validation Rule
AND(RecordType.Name = "Preliminary Transfer Credit Evaluation" &&
LastModifiedBy.Username <> 'Colette Lewis'&&
NOT(ISNEW()) &&
ISPICKVAL(PRIORVALUE(Status), "Closed") ||
ISPICKVAL(PRIORVALUE(Status), "Canceled"))
답변 5개
The way you rewrote it, now this validation rule would only show up as true IF:
Record Type is Preliminary Transfer Credit Evaluation
The Record Owner is Evaluation Specialist PTCE queue
Its not new
And the priorvalue of the status was closed/cancelled.
Not sure that is what you are looking for is it?