Formula Rule Solution:
AND(
ISPICKVAL(StageName,”Closed Lost”),
NOT(
ISPICKVAL( Competitor__c, “Competitor_Picklist_Value1”)),
NOT(
ISPICKVAL( Competitor__c, “Competitor_Picklist_Value2“)),
NOT(
ISPICKVAL( Competitor__c, “Competitor_Picklist_Value3“)
)
)
Let’s break this validation rule down. In this rule I am introducing the NOT() function which is a great function for determining is something is NOT true… or false if you are following the logic. However, the NOT() function only works with one parameter at a time. Let me explain.
THIS IS POOR SYNTAX:
NOT(
ISPICKVAL( Competitor__c, “Competitor_Picklist_Value1”),
ISPICKVAL( Competitor__c, “Competitor_Picklist_Value2”),
ISPICKVAL( Competitor__c, “Competitor_Picklist_Value3”)
)
The NOT() function will only work with one parameter.
ISPICKVAL(StageName,”Closed Lost”),
ISBLANK(Competitor__c)
)