How to create a validation rule, Contract Owner or a user(Karthikeyan Chandran) should NOT be able to 'Activate' the contract record until Contract Stage = Pending.
It should applicable on newly created records and the contract record until Contract Stage changes to "Pending".
Thanks
7 answers
Pretty much all the that happens to me! Try this one -
AND(
OR(
Owner.Id = $User.Id,
($User.FirstName + " " + $User.LastName) = "Karthikeyan Chandran"
),
TEXT(Contract_Stage__c) <> "Pending",
ISCHANGED(Status),
TEXT(Status) = "Activated"
)
