You need to sign in to do that
Don't have an account?
Chris Paris
Opportunity Validation Rule - Formula Multiple Variables
I know this is likely a quick fix but we are trying to add in a new value to an existing working validation formula. Currently, the existing validation rule below works to freeze opportunties from editing when the approval status is "sent for approval".
The formula :
AND(((ISPICKVAL( PRIORVALUE(Approval_Status__c),"Sent for Approval"))),NOT(OR($Profile.Name = "System Administrator", $Profile.Name = "Finance and Administration", $Profile.Name = "Finance Testing", $Profile.Name = "Sales Testing" )))
We are trying to use the formula above to filter for Approval Status both "Sent for Approval" and "Approved". Any help would be great!
Many Thanks!
The formula :
AND(((ISPICKVAL( PRIORVALUE(Approval_Status__c),"Sent for Approval"))),NOT(OR($Profile.Name = "System Administrator", $Profile.Name = "Finance and Administration", $Profile.Name = "Finance Testing", $Profile.Name = "Sales Testing" )))
We are trying to use the formula above to filter for Approval Status both "Sent for Approval" and "Approved". Any help would be great!
Many Thanks!
Here you are using prior value to check the old value ,But what I understood here in new formula you do n't need old valaue to compare .
If yes then use below formula it will help .
All Answers
Here you are using prior value to check the old value ,But what I understood here in new formula you do n't need old valaue to compare .
If yes then use below formula it will help .