function readOnly(count){ }
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
+ Start a Discussion
KIBLKIBL 

Validation Rule

I want to validate that a custom field is populated when a certain subtype is picked and the case status is changed to closed.  I have the rule below but it is not working.  What am I missing?

 

AND (
AND(
ISPICKVAL( SubType__c , "Replacements/Repairs/COQ Investigation"),
ISPICKVAL(Status, "Closed")),
( KI_Replacement_Order__c <> "" ))

Best Answer chosen by Admin (Salesforce Developers) 
shillyershillyer

This worked for me:

 

AND( ISPICKVAL(StageName, "Closed Won") , ISPICKVAL( DependentPicklist__c , "Some Value"), CustomField__c= "" )

 

Hope that helps,

Sati

All Answers

shillyershillyer

This worked for me:

 

AND( ISPICKVAL(StageName, "Closed Won") , ISPICKVAL( DependentPicklist__c , "Some Value"), CustomField__c= "" )

 

Hope that helps,

Sati

This was selected as the best answer
KIBLKIBL
That worked.  I tried that before but I was one character off.  Thanks for your help!