We have a few validation rules to protect our records to be modified if they meet the criteria, but a few days ago one of the validation rules stopped working, right now we don't know the exact reason.
Also we tried to debug it and if we remove the OR Section with the stage names, works perfectly, we tried many variations of this and all of those failed.
We're thinking on a workaround creating a new custom field to make the validation rule shorter, but is there any other solution that we're not seeing?
AND(
NOT($Profile.Name = "Profile A"),
NOT($Profile.Name = "Profile B"),
NOT($Profile.Name = "Profile C"),
OR(
ISPICKVAL(StageName, "Closed Won"),
ISPICKVAL(StageName, "Closed Renewal"),
ISPICKVAL(StageName, "Closed Change Order")),
OR(
ISCHANGED(AccountId),
ISCHANGED(Name),
ISCHANGED(StageName),
ISCHANGED(Description),
ISCHANGED(Amount),
ISCHANGED(Probability),
ISCHANGED(CloseDate),
ISCHANGED(OwnerId)
)
)
ISPICKVAL(StageName, 'Closed Won')
and see if it works. If all those stagenames are considered as "Won" stages, you can replace with simplyIsWon
Closed Won
? then you need PRIORVALUE function