I am creating a validation rule for an opportunity. Basically saying if you choose tick box A or tick box B then you must pick an option from the pick list.
I am new to the formulas and I have got it so my formula has 0 syntax errors but I cannot get the code to work.
OR( AND( ISPICKVAL( Preferred_Subcontractor_Supplier__c, "" ), Supplier_Required__c = TRUE,Sub_Contractor_Required__c = TRUE ))
This should say, If sub contractor required is ticked OR supplier required is ticked AND no preferred supplier is selected from the pick list then an error message will generate.