I have a custom object that track several products, but none are required to be filled out. However, if there is a product, I want to make sure my users are inputting all the necessary information. So I created this rule:
AND(
NOT(ISNULL(Product_1__c )),
AND(ISNULL(Quantity_1__c),
ISNULL(Part_Number_1__c),
ISNULL(Vendor_1__c),
ISNULL(Sell_Price_1__c)
)
)
What I'm hoping it will do is create an error if they put something in the product field, but don't fill out the rest of the information. I have one for each of my products.
But it isn't working properly when I test. What am I doing wrong?