You need to sign in to do that
Don't have an account?
Gaurii
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
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
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
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
AND( (ISPICKVAL( Status__c ,'Resolved') || ISPICKVAL(Status__c , 'Unable to resolve - Escalate to PST') ), ISPICKVAL( Action_Taken__c , '') )
Its working with this rule thanks.:)