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.

Find more posts tagged with

Formulas

Accepted answers

L_123

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

All comments

L_123

error in one of your ranges most likely

Sameer Karkhanis

You can keep it simple instead,

=COUNTIFS[Due this Week]:[Due this Week], 1, Status:Status, "In Progress")

reece.buckner

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.

reece.buckner

@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.

L_123

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

reece.buckner

@L_123 That was it, thank you!

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.