Countifs and past due formula help

I am trying to count the items that have a particular workstream, multiple status (blank, In progress) and Due date in the past. here is my formula:

=COUNTIFS([Workstream]:[Workstream], @row "QBR", [Status]:[Status], @row "In Progress", [Due Date]:[Due Date], @row <= TODAY())

the error I get is #unparseable. any ideas on help?

Thank you!

Find more posts tagged with

Accepted answers

All comments

Debbie Sawyer

Try removing the @row elements...

=COUNTIFS([Workstream]:[Workstream], "QBR", [Status]:[Status], "In Progress", [Due Date]:[Due Date], <= TODAY())

Kind regards

Debbie

Chris Rea

I would recommend:

=COUNTIFS([Workstream]:[Workstream], Workstream@row = "QBR", [Status]:[Status], Status@row = "In Progress", [Due Date]:[Due Date], [Due Date]@row <= TODAY())

If memory serves me correctly you can't just use the "@row" because smartsheet doesn't know where to look.

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.