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.5K Get Help
- 424 Global Discussions
- 136 Industry Talk
- 465 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 146 Just for fun
- 63 Community Job Board
- 465 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 301 Events
- 39 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!