Combining AND & OR in a formula

Emma Pettit
Emma Pettit ✭✭
edited 03/30/20 in Formulas and Functions

I have a sheet with the following three columns:

--Was the question asked

--Answer 1 y/n

--Answer 2 y/n

I want the formula to turn the flag red (cell already formatted for flags) if the question was asked, and either answer 1 or answer 2 were no (aka, i need all the no's from everyone who was asked the question).

So far I was able to build the OR piece but I can't figure out how to add in the AND.

I have: =IF(OR([Answer 1]@row = 0, [Answer 2]@row = 0), 1, 0)

Thank you for your help!

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!