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
Could you please use this for Type comparison?
NOT(OR(ISPICKVAL(Type,"Private Sales"), ISPICKVAL(Type, "Post Sale")))