We have a specific user that can edit Account records (use has full CRED to Account object as well as edit permissions at the field level) we want to restrict them from editing the standard field "Type" when it is NOT = Prospect or Competitor AND only be able to edit it to = "Prospect" or "Competitor".
There are 33 other values in the picklist they should not be able edit from or to select.
We want the user to experience an error if they attempt to edit/us any other values in the Type field.
I am doing this at the user level, as there is only 1 user of the same profile this will affect.
We have only 1 record type on the Account (we do not want to introduce other record types).
I have attempted this with a validation rule (which passes syntax but does not work):
AND( $User.User_18_Digit_ID__c <> "00550000003Ohx5BAG", ISCHANGED(Type), OR ( ISPICKVAL (PRIORVALUE (Type), "Prospect"), ISPICKVAL (PRIORVALUE (Type), "Competitor") ))
When I log in as the user to test, it will allow me to edit Accounts that are not Type = "Prospect" or "Competitor" (which it should not) And it will allow me to select a Picklist value for Type field that is not "Prospect" or Competitor"
I appreciate any suggestions.