+ Start a Discussion
HNT_NeoHNT_Neo 

Validation Rule ISCHANGED

I'm trying to create a validation rule that prompts users from transferring Account records to system admin. 

This VR seems to prompt all users from transferring account records to one another, but I still want users to transfer records to one another, but not to System Admin. 

Any ideas? 
AND(ISCHANGED(OwnerId), 
NOT($Profile.Name ="System Administrator") 
)
User-added image
 
Best Answer chosen by HNT_Neo
venkat-Dvenkat-D
Why do you even want to check ischanged? simply do not allow change to Admin by using 

Owner.Profile.Name = "System Administrator"

All Answers

Naval Sharma4Naval Sharma4
Try this rule.
AND(ISCHANGED(OwnerId), Owner.Profile.Name ="System Administrator" )

 
venkat-Dvenkat-D
Why do you even want to check ischanged? simply do not allow change to Admin by using 

Owner.Profile.Name = "System Administrator"
This was selected as the best answer
HNT_NeoHNT_Neo
Both of these VRs work, but one is a little easier to manage, tough call

But definitely give you credit NavalSharma4 
 
AND(ISCHANGED(OwnerId), Owner.Profile.Name ="System Administrator" )

 
HNT_NeoHNT_Neo
Do either of you know the best way to setup a custom setting using this VR? That would then allow me to use it on all objects :)
Naval Sharma4Naval Sharma4
Hi Neo,

if you will not use isChanged then system will not allow system admin to update anything on that record.

 
HNT_NeoHNT_Neo

Hi Naval Sharma4

This seems to be working too: 

 

NOT($Profile.Id = "00ed0000000vi78") 
&& 
Owner.Profile.Name = "System Administrator"