You need to sign in to do that
Don't have an account?
lburns
Formula/Validation Rule for Required Picklist field.
Hi...trying to make a picklist field required when the standard 'TYPE' field (also a picklist field) is populated with 'Vendor'. If 'Vendor' is selected, then I need to have the 'Vendor Group' field required.
AND(
ISPICKVAL( Type ,"Vendor"),
ISPICKVAL( Vendor_Group__c ) (am I missing something here?)
)
I tried the ISNULL function, but it keeps giving me an error that it's a picklist.
Thanks...
Try changing it to
ISPICKVAL( Vendor_Group__c ,"")
All Answers
Try changing it to
ISPICKVAL( Vendor_Group__c ,"")
I'm wondering if this formula will help me. I'm trying to make an Opportunity field required based on a Opportunity picklist Type Field "New Business"
AND(
ISPICKVAL( Type ,"New_Business" ),
ISPICKVAL( Inside_Sales_Rep__c," ")
)
Yeah, this one should work for you
AND(ISPICKVAL(Type, "New_Business"), (ISPICKVAL(Inside_Sales_Rep__c, "")))
I tried it and not working. Wondering if reasons b/c both are picklists. Trying to figure another way....
AND(ISPICKVAL (Type, "New Business"), ISNULL (Inside_Sales_Rep__c) )
If I think this out, if Opportunity Type = New Business, then Inside Sales Rep should not be blank, and required..however still not working.
AND(ISPICKVAL(Type, "New_Business"),
(ISPICKVAL (Inside_Sales_Rep__c, "")))
The Inside Sales Rep is a field and not a picklist. That might be the problem.
Sorry about that.
Field Label - Type
Field Name - Type
Data Type - Picklist ( one of the values is "New Business"
Field Label - Inside Sales Rep
Field Name - Inside_Sales_Rep
API Name - Inside_Sales_Rep_c
Data Type - Picklist ( filled with user names)
AND( ISPICKVAL(Type, "New_Business"), LEN( Inside_Sales_Rep__c) < 1)
Actually its a picklist field and here is a error I get. I'm going to review the formula pdfs you attached in other posts.
Error: Field Inside_Sales_Rep__c is a picklist field. Picklist fields are only supported in certain functions.
Also, in some posts your formula has a value of "New Business" and in others it's "New_Business" so you might want to check that too.
If they are both PICKLIST Fields then this formula should work fine:
AND(ISPICKVAL(Type, "New Business"), (ISPICKVAL(Inside_Sales_Rep__c, "")))
Are all of the fields in your formula located on the Opportunity Object?
That was the error. I was using "New_Business" instead of the correct way "New Business. Thanks again for the help and patience.
Chris