I am trying to write a Validation Rule that says:
If a Picklist has specific values selected, then a lookup field named "New User" on the same page must be only allowed to select a User from the lookup with a certain profile type, or there would be an error shown. Here is what I have done so far and it is not working:
AND( NewUser__c $Profile.Name = "Seller", OR( ISPICKVAL(Style__c, 'Magazine'), ISPICKVAL(Style__c, 'Digital'), ISPICKVAL(Style_Type__c, 'Media') ) )
I think the
AND statement is completely wrong. I'm stuck. Any and all help is appreciated. Thanks!