• Mags Doheny 5
  • NEWBIE
  • 0 Points
  • Member since 2022

  • Chatter
    Feed
  • 0
    Best Answers
  • 0
    Likes Received
  • 0
    Likes Given
  • 0
    Questions
  • 1
    Replies
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"))) 
)