# IF/AND/OR Functions

Options

Good Morning,

I am looking to get some help setting up a formula based on a few conditions. The first condition is IF column BAG COUNT has a value = 0 AND column Response Form Received = Y then if the statement is true it should input YES into All documents if False NO. The second condition is if column BAG COUNT has a value >0 AND column Response Form Received = Y AND column Destruction Form Received = Y then if the statement is true it should input YES into column All Documents, if false NO should be inputted.

Basically I have 2 different conditions based on column bag destroyed and depending on if there is a value larger than zero will determine if both forms are required or only 1.

What would be the easiest formula to achieve this? I have tried multiple reiterations of IF/AND statements but the whole string always puts out an error.

• ✭✭✭✭✭✭
Options

Try something like this:

=IF(OR(AND([Bag Count]@row = 0, [Response Form Received]@row = "Y"), AND([Bag Count]@row> 0, [Response Form Received]@row = "Y", [Destruction Form]@row = "Y")), "YES", "NO")

• ✭✭✭✭✭✭
Options

Try something like this:

=IF(OR(AND([Bag Count]@row = 0, [Response Form Received]@row = "Y"), AND([Bag Count]@row> 0, [Response Form Received]@row = "Y", [Destruction Form]@row = "Y")), "YES", "NO")

• Options

Thanks Paul that worked! Appreciate your help!

• ✭✭✭✭✭✭
Options

Happy to help. 👍️

## Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!