Question
I need a little help with a validation rule on my case object.
We want to require our case agents to fill "Remedy or Componet Failure" if "RMA Remedy or Componet Failure" is blank when closing a case.
Here is the VR i have so far, but this rule will not allow us to create a case becuase it wants the "Remedy or Componet Failure" filled out.
AND(NOT(ISPICKVAL(Status,"Closed")),(ISBLANK(TEXT(RMA_Remedy_or_Component_Failure__c))), ISBLANK(TEXT( Remedy_or_Component_Failure__c )))
Answer:
AND(
TEXT(Status) = "Closed",
ISBLANK(TEXT(RMA_Remedy_or_Component_Failure__c)),
ISBLANK(TEXT(Remedy_or_Component_Failure__c)))
The reason it wasnt working was because of your 'NOT' clause!
No comments:
Post a Comment