0

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
If this question can be reworded to fit the rules in the help center, please edit the question.

  • 1
    Do you mean a field on Opportunity named "Notes" or are you trying to require something in the Notes & Attachments related list if the stage is closed? – Blair Kristin Feb 8 '16 at 17:07
  • What problems are you having? What do you need help with? – Sebastian Kessel Feb 8 '16 at 17:40
1

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)

Not the answer you're looking for? Browse other questions tagged or ask your own question.