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
rtrevo915rtrevo915 

Requiring a Resolution Prior to Resolving a Case

I'm attempting to write a Validation Rule that will require a value in my Call Resolution Field when the user Resolves the Case, but allows them to leave the field blank when the case is in any other status.  Here is what I've tried so far:

 

AND
(OR(ISPICKVAL(Status ,"Resolved"),
ISPICKVAL(Status ,"Closed")),


NOT(ISPICKVAL(ACTS_CALL_RESOLUTION__c, "")),


OR( $RecordType.Name='Level_1_Rep_Layout',
$RecordType.Name='Level_2_Rep', 
$RecordType.Name='Team_Leads', )
)

 

I've also tried pulling the NOT statement out, but either way I can Resolve a case without the field being populated.

 

Any help is greatly appreciated.

 

Thanks,

 

Ryan

Steve :-/Steve :-/

Here you go

 

AND (ISPICKVAL(Picklist_2, ""),
OR( ISPICKVAL(Picklist_1, "Value_1"),
ISPICKVAL(Picklist_1, "Value_2")),
OR($RecordType.Name = "RecType_1",
$RecordType.Name = "RecType_2",
$RecordType.Name = "RecType_3"))
 
 so yours should look sumthin' like:
AND (ISPICKVAL(ACTS_CALL_RESOLUTION__c, ""),
OR( ISPICKVAL(Status ,"Resolved"),
ISPICKVAL(Status ,"Closed")),
OR($RecordType.Name = "Level_1_Rep_Layout",
$RecordType.Name = "Level_2_Rep",
$RecordType.Name = "Team_Leads"))
 
 
Message Edited by Stevemo on  02-23-2010 11:36 AM