Tuesday, 25 March 2014

Help with a Case Validation Rule

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