Need Help Writing Validation rule for cases

I hate having to ask but it’s my first week on the job and I already feel like I’m failing…I need to create a validation rule with the following criteria and keep coming up with syntax errors. Basically if the case matches the the criteria and the fields in quotes are blank and user attempts to close case I need it to give the user an error:

Picklist when creating – Record Type ID = 012C00000004YW5
Picklist – Team__c = Vendor Services
Picklist – Status = Closed or Auto Follow-up

field blank “Resolution_Type__c”, “Resolution__c”, “Case_Category__c”, and
“Type”

Answer

Please try this:

AND(
  (RecordTypeID = '012C00000004YW5'),
  ISPICKVAL(Team__c, 'Vendor Services'),
  OR(
    ISPICKVAL(Status, 'Closed'),
    ISPICKVAL(Status, 'Auto Follow-up')
  ),
  ISPICKVAL(Resolution_Type__c,''),
  ISPICKVAL(Resolution__c,''),
  ISPICKVAL(Case_Category__c,''),
  ISPICKVAL(Type,'')
)

Attribution
Source : Link , Question Author : Marina P. , Answer Author : Brian Mansfield

Leave a Comment