Skip to main content

I'm trying to create a validation rule that says: if opportunity record type is consignment and the opportunity type is not equal to Private Sale or Post Sale then a consignment ID is required. I'm getting the following syntax error: "Field Type is a picklist field. Picklist fields are only supported in certain functions"

 

This is what I have so far:

 

RecordTypeName__c = "Consignment"

&&

OR(ISPICKVAL(Type <> "Private Sales"),

OR(ISPICKVAL(Type <> "Post Sale")))

&&

ISCHANGED(StageName)

&&

OR(ISPICKVAL(StageName, 'Consigned'), 

OR(ISPICKVAL(StageName, "Re-Offered")))

&&

OR(Consignments_ID__c = 0, ISBLANK(Consignments_ID__c))

5 answers
  1. Oct 19, 2021, 2:07 PM

    Could you please use this for Type comparison?

     

    NOT(OR(ISPICKVAL(Type,"Private Sales"), ISPICKVAL(Type, "Post Sale")))
0/9000