If PDCA Range 2 has production anywhere in it and PDCA 1 is greater than 0 then count it.

Options

Current Formula =COUNTIFS({PDCA Range 2}, HAS(@cell, "Production"), IF({PDCA Range 1}), >0)

Best Answer

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!