function readOnly(count){ }
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
+ Start a Discussion
GauriiGaurii 

validation rule if status ischanged then ActionTaken should not be blank

The field should be populate field named as action taken should populate on closure not on creation ie when my status is Resolved or Unable to resolve-EscalatetoPST.
My validation rule:

 

AND
((ISCHANGED(Status__c)),
And(OR(ISPICKVAL( Status__c,'Resolved'),
ISPICKVAL(Status__c,'Unable to resolve-EscalatetoPST')),
ISPICKVAL( Action_Taken__c,'')) )
its not working for Unable to resolve-EscalatetoPST only working for resolve. 

why? plz help

Best Answer chosen by Admin (Salesforce Developers) 
GauriiGaurii

AND( (ISPICKVAL( Status__c ,'Resolved') || ISPICKVAL(Status__c , 'Unable to resolve - Escalate to PST') ), ISPICKVAL( Action_Taken__c , '') )

 

Its working with this rule thanks.:)

All Answers

Suresh RaghuramSuresh Raghuram



And(ISCHANGED(Status__c),(OR(ISPICKVAL( Status__c,'Resolved'),
ISPICKVAL(Status__c,'Unable to resolve-EscalatetoPST'))),
ISPICKVAL( Action_Taken__c,'')) )

 

Try this.

 

If this answers your question make this as solution and give kudos

GauriiGaurii

And(ISCHANGED(Status__c),(OR(ISPICKVAL( Status__c,'Resolved'),
ISPICKVAL(Status__c,'Unable to resolve-EscalatetoPST'))),
ISPICKVAL( Action_Taken__c,'')) ) 

 

Still its not working with Unable to resolve ie the scenario is like this when ever i select the the status resolve or unable to resolve it should stop n should populate the error msg that action taken is required.

Plz help

GauriiGaurii

AND( (ISPICKVAL( Status__c ,'Resolved') || ISPICKVAL(Status__c , 'Unable to resolve - Escalate to PST') ), ISPICKVAL( Action_Taken__c , '') )

 

Its working with this rule thanks.:)

This was selected as the best answer