function readOnly(count){ }
Sign Up ›
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
Learn More

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
Dosbol TDosbol T 

Prevent closing Case if 2 other fields are not filled in - validation rule

Hello, please help me with this. 
Validation Rule: prevents Case to be closed if the CasePicklist1__c is not filled AND CasePicklist2__c = Value 1 & Value 2. 
AND(
    ISCHANGED(Status),
    ISPICKVAL(Status,"Closed"),
      OR(ISPICKVAL( CasePicklist2__c ,"Value1")),
        ISPICKVAL( CasePicklist2__c  ,"Value2"),
        ISBLANK(TEXT( CasePicklist1__c ))
)

Much appreciated.
AnkaiahAnkaiah (Salesforce Developers) 
Hi,
Try with below rule.
  
AND(
    ISCHANGED(Status),
    ISPICKVAL(Status,"Closed"),
      OR(ISPICKVAL( CasePicklist2__c ,"Value1"),
        ISPICKVAL( CasePicklist2__c  ,"Value2")),
        ISBLANK(TEXT( CasePicklist1__c ))
)

If this helps, Please mark it as best answer.

Thanks!!​​​​​​​