Countifs + AND/OR functions




I'm trying to create a table to display via a dashboard that shows project status in three categories: Complete, in progress, other. Other includes 3 different values that i need to group into that "other" category.

How do you smart folks recommend i do this. I've tried a bunch of things but i get invalid #INVALID DATA TYPE. my line for the straight forward categories is below.

=COUNTIFS({SDU Project Map V2 Range 6}, "Q1", {SDU Project Map V2 Range 9}, "In progress", {SDU Project Map V2 Range 7}, "2018-19")

Much appreciated







Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!