CountIFS Multi-Select Criteria

Smartsheet Community:

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.

Current Formula:

=COUNTIFS(Project:Project, "OPAL", [Change Type]:[Change Type], HAS(@cell, "Scope")), [Change Type]:[Change Type], HAS(@cell, "Time"))


Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!