Countifs / Contains

Hello all,

I had this formula working, I'm not sure what I changed to make it stop working. I've looked at it and played with it to get it working again and it won't. Please someone show me what I'm doing wrong.

=COUNTIFS([Due this Week]:[Due this Week], 1, Status:Status, CONTAINS("In Progress", @cell))

I just want to count how many tasks are In Progress This Week.


Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!