Count if Production is anywhere in the cell.

PDCA range 2 is a drop down list. It is counting it if Production is the ONLY thing selected. If there are multiple things selected, it wont find it in the list and count it. Formula =COUNTIFS({PDCA Range 2}, "Production", {PDCA Range 1}, FIND("OK 3", @cell) = 0)

Best Answer

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!