Trying to combine IF, OR, & AND

Henry L.
Henry L. ✭✭
edited 10/03/22 in Formulas and Functions

Hi all,

As the title states, I am trying to create a helper column that is checked or unchecked based on a few conditions. I want to check the helper column box if statements 1 and 2 are both true or if statements 1 and 2 are both false. I had written:

IF(OR(AND(statement 1@row = 1, statement 2@row = 1), AND(statement 1@row = 0, statement 2@row = 0)), 1, 0)

Not certain if this is the right order or even the way to go. Please let me know what you all think.

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!