Validation Rule

Question

Good Morning Guys, I need help with a Validation rule Formula. This is to make a picklist field required on case whenever an agent is trying to close a case.

Eric Praud · Accepted Answer

Hi James,   Try this:   AND(ISPICKVAL(Status, "Closed"), ISBLANK(TEXT(Picklist__c)))

James .Hancock · Answer

Eric so it has to be either one of those status value and the firstcallresolution, Im getting an error for this one.   And (   ISPICKVAL(Status, "Successful, Provided Consumer Information"),    ISPICKVAL(Status, "Successful, Consumer Already Resolved"),   ISPICKVAL(Status, "Successful, Resolved Consumer Issue"),   ISPICKVAL(Status, "Transferred, ServiceNow Ticket"),   ISPICKVAL(Status, "Unsuccessful, Unable to Reach Consumer"),   ISPICKVAL(Status, "Unsuccessful, Other"),     ISPICKVAL(Status, "Successful, Other")   OR(   ISBLANK(TEXT( FirstCallResolution__c ),   )))

Validation Rule

Data Management

Related Learning

More Help