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
-
Look down the columns that you are referencing. I bet you will find a formula error inside of one of them that you will have to fix
Answers
-
error in one of your ranges most likely
-
You can keep it simple instead,
=COUNTIFS[Due this Week]:[Due this Week], 1, Status:Status, "In Progress")
-
I tried that, it tells me INVALID DATA TYPE. I have tried several versions of this formula in different ways and it always tells me invalid data type.
-
@L_123 can you please elaborate on this? I am not sure what that error may be. It is referencing two existing columns, it isn't a problem with the column name within the formula. I changed the column type for Due this Week from text which read "This Week" to the checkbox, which did not make a difference.
-
Look down the columns that you are referencing. I bet you will find a formula error inside of one of them that you will have to fix
-
@L_123 That was it, thank you!
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.9K Get Help
- 441 Global Discussions
- 139 Industry Talk
- 472 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 68 Community Job Board
- 496 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!