You need to sign in to do that
Don't have an account?
Prasanth 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 ?
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 ?
AND(ISPICKVAL( StageName ,'CLOSED WON'), ISBLANK(TEXT(Type)))
Please Select this as Best Answer if it helps you.
All Answers
AND(ISPICKVAL(Stage,'CLOSED WON'),ISNULL(Customer_Type__c))
Please Mark this as BEST ANSWER if it helps you.
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
AND(ISPICKVAL( StageName ,'CLOSED WON'), ISBLANK(TEXT(Type)))
Please Select this as Best Answer if it helps you.
Thanks Rahul, This worked, will the formula changes, if any field is a custom field ?
Please close this thread as solved.........and make it as Best Answer so that others also get help from this
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?