COUNTIFS formula to pull number of overdue tasks associated with owner

I am trying to pull data for a Sheet Summary with this formula:

=COUNTIFS([Owner:Owner], "jane doe", [Deadline:Deadline], "<" & TODAY())

I am getting an unparseable error, it seems to be around the () next to TODAY.

What do I need to change to have my formula be correct?

Find more posts tagged with

Accepted answers

Hey @Abby Stanek,

I just realized what the issue is! Remove all the brackets around your column ranges:

=COUNTIFS(Owner:Owner, "jane doe", Deadline:Deadline, <TODAY())

You only use brackets in ranges if the column name has a space in it, otherwise don't use them for one word column titles, like so:

=COUNTIFS([Owner Name]:[Owner Name], "Jane Doe", Deadline:Deadline, <TODAY())

All comments

Hey @Abby Stanek,

You shouldn't need the quotes around the <, it should just look like this:

=COUNTIFS([Owner:Owner], "jane doe", [Deadline:Deadline], <TODAY())

Hope this helps!

I just switched it to the below formula and am still getting an unparseable error

https://community.smartsheet.com/discussion/comment/437096#Comment_437096

=COUNTIFS([Owner:Owner], "jane doe", [Deadline:Deadline], <TODAY())

Hey @Abby Stanek,

I just realized what the issue is! Remove all the brackets around your column ranges:

=COUNTIFS(Owner:Owner, "jane doe", Deadline:Deadline, <TODAY())

You only use brackets in ranges if the column name has a space in it, otherwise don't use them for one word column titles, like so:

=COUNTIFS([Owner Name]:[Owner Name], "Jane Doe", Deadline:Deadline, <TODAY())

https://community.smartsheet.com/discussion/comment/437100#Comment_437100

This did it!

NVM

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.