You need to sign in to do that
Don't have an account?
swain 10
Validation Formula for leting only 3 users to edit specific field
Hi I am writting a Validation for restricting editing of some field and only giving access 3 user having Profile Admin , User name xyz and Record owner. But my logic is failing . I used different way but infortunate . Please help.
AND( ISCHANGED( BusinessStrategy__c ),ISCHANGED( BusinessStrategyComments__c ),ISCHANGED( DecisionDrivers__c ),ISCHANGED( DecisionDriversComments__c ),ISCHANGED( CustomerOwnerInsight1__c ),ISCHANGED( CustomerOwnerInsight1Comment__c ),ISCHANGED( CustomerOwnerInsight2__c ),ISCHANGED( CustomerOwnerInsight2Comment__c ),ISCHANGED( CustomerOwnerInsight3__c ),ISCHANGED( CustomerOwnerInsight3Comment__c ),AND(
$Profile.Name <> 'System Administrator' ,
$User.Email <> 'scallaway@prologis.com' ,
$User.Id <> Owner.Id ))
AND( ISCHANGED( BusinessStrategy__c ),ISCHANGED( BusinessStrategyComments__c ),ISCHANGED( DecisionDrivers__c ),ISCHANGED( DecisionDriversComments__c ),ISCHANGED( CustomerOwnerInsight1__c ),ISCHANGED( CustomerOwnerInsight1Comment__c ),ISCHANGED( CustomerOwnerInsight2__c ),ISCHANGED( CustomerOwnerInsight2Comment__c ),ISCHANGED( CustomerOwnerInsight3__c ),ISCHANGED( CustomerOwnerInsight3Comment__c ),AND(
$Profile.Name <> 'System Administrator' ,
$User.Email <> 'scallaway@prologis.com' ,
$User.Id <> Owner.Id ))