0
AND(ISNEW(),
    IF(OR(TEXT(StageName)= "10% Opportunity Identified",
    TEXT(StageName)="20% - Opportunity qualified    "),
    FALSE,TRUE))
0

1 Answer 1

0

The validation rule should be

AND( ISNEW(), AND(TEXT(StageName) != "10% Opportunity Identified", TEXT(StageName) !="20% - Opportunity qualified") )

4
  • by using above,none of the values work for me,its give error everytime when selecting,
    – shweta
    Jul 15, 2017 at 7:23
  • You need to fire the validation rule when these values are not selected?
    – Ankita
    Jul 15, 2017 at 7:24
  • yes,we need to fire the validation rule when these values are not selected
    – shweta
    Jul 15, 2017 at 7:30
  • Edited the rule. Try this. Do verify the picklist values also for typos
    – Ankita
    Jul 15, 2017 at 7:34

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .