Using COUNTIFS and OR statement

You're all so amazingly helpful that I'm back. I think this is an easy fix for most, but I'm scratching my head.

I have a column named Status with multiple drop down options, of which only one can be used. I also have a column named PMO that is a checkmark.

I want to get a count of PMO flagged rows that fall within several statuses (planning, execution, monitoring). The formula below works for one status - how do I sneak in the OR to pick up each of those three?

=COUNTIFS(Status:Status, "Planning", PMO:PMO, 1)



Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!