I am attempting to write a validation rule which will not allow the box to be checked until certain fields are populated. I am also open to making those fields required if the box is checked. My checkbox field is "Request Asset Number" and the required fields are Asset Manager, Financial Analyst, Asset Name and Investor #.
I've tried ISBLANK and IF statements, but it isn't working at all.
One other piece that might make a difference is Investor # is a multi-pick picklist.
Thanks!
Shelby
5 Antworten
Try this = AND(
Request_Asset_Number__c = TRUE,
OR(
ISBLANK(Asset_Manager__c),
ISBLANK(Financial_Analyst__c),
ISBLANK(Asset_Name__c),
ISBLANK(Investor_Number__c)
)
)
