Countifs not working for project by month


Hello all,

I want to count 3 different project types, by the number our team does each month. Two of the 3 project types are coming back with data. Why am I getting an error on the other? Here is a snippet:

I keep getting the invalid data type error on it.



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!