See formula below

If production is found anywhere in in range 2 and OK 3 is not found in range 1 return the data in Range 3 =COUNTIFS({PDCA Range 2}, HAS(@cell, "Production"), {PDCA Range 1}, FIND(NOT({PDCA Range 1} = "OK 3"), @cell) = {PDCA Range 3})

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!