Count "text" if the status is "Doing"
I'd like a way to count Theme column (Text Column) if "IVR" appears, AND if the Status Column (Dropdown column) is either "Backlog" or "To Do" or "Doing"
I can get a simple countif formula to work, but can't figure out how to add a second criteria based on status
i tried ones along the lines of
=COUNTIF(AND(Theme:Theme, "IVR"), IF(Status:Status, "Doing"))
=COUNTIFS(Theme:Theme, ="IVR", Status:Status, ="To Do", "Doing", "Backlog")
Help Article Resources
Check out the Formula Handbook template!