+ Start a Discussion
Prasanth Reddy MPrasanth Reddy M 

How to make one picklist field required based on value in another picklist field?

Hi,

I have a picklist field called Customer Type in Opportunity page with options, NEW, EXISTING and INACTIVE. I wan to make it required, if Opportunity stage is CLOSED WON.

How can this be achieved ?
Best Answer chosen by Prasanth Reddy M
Rahul Sangwan7341Rahul Sangwan7341
Try this one:

AND(ISPICKVAL( StageName ,'CLOSED WON'), ISBLANK(TEXT(Type)))

Please Select this as Best Answer if it helps you.

All Answers

Rahul Sangwan7341Rahul Sangwan7341
Best is write Validation Rule on Opportunity.

AND(ISPICKVAL(Stage,'CLOSED WON'),ISNULL(Customer_Type__c))

Please Mark this as BEST ANSWER if it helps you.
Prasanth Reddy MPrasanth Reddy M
Hi Rahul,

I am getting below error, when i used above formula.

Error: Field Customer_Type__c is a picklist field. Picklist fields are only supported in certain functions
Rahul Sangwan7341Rahul Sangwan7341
are you using standard fields???????? may i know the API name of picklist fields?
Prasanth Reddy MPrasanth Reddy M
yes both are standard fields, 'stage' and 'type'.
Rahul Sangwan7341Rahul Sangwan7341
Try this one:

AND(ISPICKVAL( StageName ,'CLOSED WON'), ISBLANK(TEXT(Type)))

Please Select this as Best Answer if it helps you.
This was selected as the best answer
Prasanth Reddy MPrasanth Reddy M

Thanks Rahul, This worked, will the formula changes, if any field is a custom field ?
Rahul Sangwan7341Rahul Sangwan7341
No........it will work fine.

Please close this thread as solved.........and make it as Best Answer so that others also get help from this
Jacklyn BentonJacklyn Benton
I am doing this for two picklist values, the syntax is correct but it is allowing me to save the Opportunity still without having a value in the field I want required (Packaging Solutions picklist).

AND(ISPICKVAL( Product__c,'Packaging Solutions'), ISBLANK(TEXT(Packaging_Solutions__c)))

Do I need to make this field required on the page layout in order for the formula to work?