I need help with my COUNTIFS formula

I am trying to get a count of rows on a sheet that are not Completed AND are not a Sub-Task. My formula works on a syntax level, but it is not coming back with the right answer. Can someone help me figure out what I'm doing wrong?

=COUNTIFS({PMO Support Tasks Range 5}, "<>*Completed*", {PMO Support Tasks Range 1}, "<>*Sub-Task")

@Paul Newcome tagging you because you are a whiz with formulas!

Find more posts tagged with

Accepted answers

All comments

Mathieu PERSICO

Hi Kelly,

Try this instead:

=COUNTIFS({PMO Support Tasks Range 5}, <>"Completed", {PMO Support Tasks Range 1},<>"Sub-Task")

Have a good day,

Paul Newcome

Haha. Thanks for the vote of confidence. Mathieu's solution above should work for you. It looks like your criteria are set more for Excel than in Smartsheet.

In Smartsheet, if you put quotes around something then it will look for that exact string including the symbols to be in the cells. Smartsheet also does not recognize * as a wildcard, so that is also something you are going to want to keep in mind. There are solutions to account for that though such as incorporating a FIND, CONTAINS, or HAS function.

Kelly Gabel

You both rock! Thank you! It worked :)

Paul Newcome

Sure thing. 👍️

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, latest, sort, sortType, lookupSort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.