I am trying to create a validation rule where if Stage is Closed Lost or Cancelled the Notes field is required. I am having problems with the formula.
closed as off-topic by Adrian Larson♦, Himanshu, Brian Mansfield, Vamsi Krishna, Boris Bachovski Feb 9 '16 at 1:27
This question appears to be off-topic. The users who voted to close gave this specific reason:
- "Questions on problems in code you've written must describe the specific problem and include valid code to reproduce it. For help writing short, self-contained syntactically-valid examples, see: SSCCE.org" – Adrian Larson, Himanshu, Brian Mansfield, Vamsi Krishna, Boris Bachovski
That should be very straight forward, try below expression, make sure the field names are correct.
(ISPICKVAL(Status__c, "Closed Lost") || ISPICKVAL(Status__c, "Cancelled")) && ISBLANK(Notes__c)