CountIFS Multi-Select Criteria
My Change Type Column Allows Multiple Values. Therefore, my Formula is Looking to See if it Has Scope or Time. If it does, then it Should Count. I Think The HAS Part of My Formula is Out of Place.
=COUNTIFS(Project:Project, "OPAL", [Change Type]:[Change Type], HAS(@cell, "Scope")), [Change Type]:[Change Type], HAS(@cell, "Time"))
Help Article Resources
Check out the Formula Handbook template!