So i have two formulas , one works and one does not; hoping someone can see what i am missing here. i have four columns that i need to take into consideration before i automatically check a checkbox . using two of the conditions works; i add the third in the second example and it blows up.
thanks in advance:
works:
=IF(AND([Const Analyst Initial Check]39 = "Yes", OR([BACnet Analysts Initial Check]39 = "Yes-Ed", [BACnet Analysts Initial Check]39 = "Yes-Kevin")), 1, 0)
does not work:
=IF(AND([Const Analyst Initial Check]39 = "Yes",OR([First BACnet Router in Building?]39 =”Yes”, [First BACnet Router in Building?]39 = “No”),OR([BACnet Analysts Initial Check]39 = "Yes-Ed", [BACnet Analysts Initial Check]39 = "Yes-Kevin")), 1, 0)