IF/AND/OR Functions

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.


Best Answer

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!