Sign Up ›
  • Alesha Kuhlman
  • NEWBIE
  • 10 Points
  • Member since 2017
  • Chatter
    Feed
  • 0
    Best Answers
  • 0
    Likes Received
  • 0
    Likes Given
  • 1
    Questions
  • 2
    Replies
SOLVED
3 replies

Trying to get a Validation rule to work but it is not working? Any help is appreciated.

AND(
Or(
(ISPICKVAL(StageName , "9 - Closed/Lost (0%)")),
(Ispickval(StageName, "6 - Closed/Won (100%)"))),
 
ISBLANK(Text( Close__c )), 
 
or(not
($RecordType.Name = "Existing Business Renewal '17",
$RecordType.Name="Service/SOW '17",
$RecordType.Name="Recurring Revenue"))
)
 
SOLVED
3 replies

Trying to get a Validation rule to work but it is not working? Any help is appreciated.

AND(
Or(
(ISPICKVAL(StageName , "9 - Closed/Lost (0%)")),
(Ispickval(StageName, "6 - Closed/Won (100%)"))),
 
ISBLANK(Text( Close__c )), 
 
or(not
($RecordType.Name = "Existing Business Renewal '17",
$RecordType.Name="Service/SOW '17",
$RecordType.Name="Recurring Revenue"))
)