You need to sign in to do that
Don't have an account?

Required Picklist Field
This is similar to my last request, but the required field is a picklist. I used the last formula for a text field needs to be completed before an opportunity is saved:
AND(
ISPICKVAL(Reseller_Involved__c,"Yes"),
LEN(Reseller_Name__c)=0
)
Now, I need a picklist field to be required: If Picklist field 'Type' (standard field) is selected 'Vendor', then Picklist field 'Vendor Group' (custom) is required. I have:
AND(
ISPICKVAL(TYPE,"Vendor"),
ISPICKVAL(Vendor_Vendor__c) (I know I'm missing something here)
)
What is missing or do I have the wrong function in the second line? Thx.
For picklist, if you want your validation rule to fire off when Type has picklist value of "Vendor" and Vendor Group is empty, then just use empty double quotes like this:
AND(
ISPICKVAL(TYPE,"Vendor"),
ISPICKVAL(Vendor_Vendor__c."")
)