How to avoid counting a drop down option?

Options

I have one drop down option which is used on 3 cells, 2 cells have "EVT" and "OK2Fab" and 1 cell "EVT" "OK2Fab" "OK2Tool", when I use: COUNTIF({WHS Hot Issue Tracker_NO Range 3}, AND(HAS(@cell, "OK2Fab"), HAS(@cell, "EVT"))) It counts 3 and when I use COUNTIF({WHS Hot Issue Tracker_NO Range 3}, AND(HAS(@cell, "EVT"), HAS(@cell, "OK2Fab"), AND(HAS(@cell, "OK2Tool")))) it counts 2. So EVT OK2Fab = 3 which is incorrect (should be 2) as I want only the two options to be counted for. How can I just count EVT and OK2Fab? and remove the option with OK2Tool?



Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!