function readOnly(count){ }
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
+ Start a Discussion
lburnslburns 

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.

zen_njzen_nj

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."")

 

)