I have a validation rule on Opportunity that will prevent user from update to Opportunity when Opportunity reach Closed Won. This will only allow some specific profile to update to Closed Won Opportunities. This is what the validation rule look like:
$Profile.Name <> "System Administrator" && Text(StageName) = "Closed Won" && NOT(ISCHANGED(LeadSource))
Now I want to make an exception for a group of users in Profile "Sales Executives" so they will be able to update to a checkbox field call "Checked Opp" when opportunity in Closed Won stage so I make change it to this
$Profile.Name <> "System Administrator" && Text(StageName) = "Closed Won" && NOT(ISCHANGED(LeadSource)) && ($Profile.Name <> "Sales Executive" && NOT(ISCHANGED(Checked_Opp__c)))
But the problem is when I change Checked Opp field and any other field like Opportunity Name then then this validation rule is NOT running. Any suggestion for my case ?