Skip to main content
In my org, I have this complicated Validation rule requirement. I have this validation that if status is new nobody should be able to edit except Billing and System admin profile but we have some approval process fire at the same time and that is blocking user so I need changes in below Validation rule. 

 

AND(

 

$Profile.Name <> 'Billing',

 

$Profile.Name <> 'System Administrator',

 

OR(

 

RecordType.Name = 'PO Request',

 

RecordType.Name = 'Invoice'

 

),

 

TEXT(Status__c) <> 'New'

 

)

 

Requirement -

 

USer should be able to edit if 

 

Status = New

 

OR 

 

Status = Pending Approval AND Prior Status = New 

 

OR 

 

Status = Approved/ Rejected AND PRIOR Status = Pending Approval. 
12 respostas
  1. 4 de nov. de 2018, 08:40
    Were you able to figure it out?
0/9000