Sign Up ›

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
Traci Whetzel 8Traci Whetzel 8 

If picklist value is selected make other picklist value fields required

Trying to create a validation where Equipment Feedback is selected in the VOC Description picklist field, and then make the following picklist fields required (with any value). 

AND(ISPickval( VOC_Description__c  ,'Equipment Feedback'),
(Ispickval(Brand__c ,"")
((Ispickval(Condition__c,"")
(Ispickval(Model__c,"")
(Ispickval(Product_Family__c,"")
(Ispickval(Brand__c,"")
(Ispickval(Product_Type__c,"")))))))
Best Answer chosen by Traci Whetzel 8
kamala swarnalathakamala swarnalatha
HI,

Try this one,

AND(ISPICKVAL( VOC_Description__c  ,"Equipment Feedback"),
ISBLANK(TEXT(Brand__c)),
ISBLANK(TEXT(Condition__c)),
ISBLANK(TEXT(Model__c)),
ISBLANK(TEXT(Product_Family__c)),
ISBLANK(TEXT(Product_Type__c)))

Hope this helps!
Please mark it as solved if my reply was helpful. It will make it available for other as the proper solution.

Thanks,
Kamala
Sweet Potato Tec.

All Answers

kamala swarnalathakamala swarnalatha
Hi,

Try this one,

AND(ISPICKVAL( VOC_Description__c  ,'Equipment Feedback'),
ISBLANK(ISPICKVAL(Brand__c)),
ISBLANK(ISPICKVAL(Condition__c)),
ISBLANK(ISPICKVAL(Model__c)),
ISBLANK(ISPICKVAL(Product_Family__c)),
ISBLANK(ISPICKVAL(Product_Type__c)))

Hope this helps!
Please mark it as solved if my reply was helpful. It will make it available for other as the proper solution.

Thanks,
Kamala
Sweet Potato Tec.


 
Raj VakatiRaj Vakati
Use this 
  
AND(ISPICKVAL( VOC_Description__c  ,'Equipment Feedback'),
OR(ISBLANK(ISPICKVAL(Brand__c)),
ISBLANK(ISPICKVAL(Condition__c)),
ISBLANK(ISPICKVAL(Model__c)),
ISBLANK(ISPICKVAL(Product_Family__c)),
ISBLANK(ISPICKVAL(Product_Type__c))
))

 
Traci Whetzel 8Traci Whetzel 8
Receiving errors on both solutions, same error. User-added image
Raj VakatiRaj Vakati
Use this one 
  
AND(
ISPICKVAL( VOC_Description__c  ,'Equipment Feedback'),
OR(ISBLANK(TEXT(Brand__c)),
ISBLANK(TEXT(Condition__c)),
ISBLANK(TEXT(Model__c)),
ISBLANK(TEXT(Product_Family__c)),
ISBLANK(TEXT(Product_Type__c))
))

 
kamala swarnalathakamala swarnalatha
HI,

Try this one,

AND(ISPICKVAL( VOC_Description__c  ,"Equipment Feedback"),
ISBLANK(TEXT(Brand__c)),
ISBLANK(TEXT(Condition__c)),
ISBLANK(TEXT(Model__c)),
ISBLANK(TEXT(Product_Family__c)),
ISBLANK(TEXT(Product_Type__c)))

Hope this helps!
Please mark it as solved if my reply was helpful. It will make it available for other as the proper solution.

Thanks,
Kamala
Sweet Potato Tec.
This was selected as the best answer
Traci Whetzel 8Traci Whetzel 8
Thanks, Kamala, yours worked. Raj V, yours did not. The code was correct, but the validation did not. It would not allow me to save, even though I had those values populated.