Sign Up ›
  • Sarah McMillian
  • NEWBIE
  • 10 Points
  • Member since 2015
  • Operations Manager
  • Yodle, Inc.
  • Chatter
    Feed
  • 0
    Best Answers
  • 0
    Likes Received
  • 0
    Likes Given
  • 1
    Questions
  • 1
    Replies
SOLVED
4 replies

Not(ISPICKVAL) Validation Rule Helpppp

I want to write a validation rule in which it only applies for a certain record type and a certain status, but then only applies if one of two other fields aren't a certain value.  Here's what I have and it's not working when I test.  It seems to be the last part that's not picking up correctly.

AND( 
RecordTypeId = "012320000009ect", 
ISPICKVAL(Status,"Completed"), 
OR(NOT(ISPICKVAL(Resolution_Attempt_Status_1__c,"Completed")),NOT(ISPICKVAL(Attempt_2_Result__c,"Completed"))) 
)
SOLVED
4 replies

Not(ISPICKVAL) Validation Rule Helpppp

I want to write a validation rule in which it only applies for a certain record type and a certain status, but then only applies if one of two other fields aren't a certain value.  Here's what I have and it's not working when I test.  It seems to be the last part that's not picking up correctly.

AND( 
RecordTypeId = "012320000009ect", 
ISPICKVAL(Status,"Completed"), 
OR(NOT(ISPICKVAL(Resolution_Attempt_Status_1__c,"Completed")),NOT(ISPICKVAL(Attempt_2_Result__c,"Completed"))) 
)