Formula to count status and due date in the past

Hi, hoping that someone can help...

I'm trying to add a field into my Sheet Summary, to highlight tasks that are overdue, but need to excluded tasks that are 'Complete'. This is what I've tried, however the error message is #Unparseable.

=COUNTIF(Launch:Launch), <TODAY(), + COUNTIF(Status:Status, "In Progress"), (Status:Status, "Under Analysis")

Any ideas? Thank you

Find more posts tagged with

Accepted answers

All comments

Aravind GP

Hi Simone,

It will be helpful if you can give a screenshot. You can possibly use this formula.

=COUNTIFS(Status:Status, "In Progress", Launch:Launch, <TODAY()) + COUNTIFS(Status:Status, "Under Analysis", Launch:Launch, <TODAY())

Simone Georgiou

Perfect, thank you! This is what has worked :)

=COUNTIFS(Status:Status, "In Progress", Launch:Launch, @cell < TODAY()) + COUNTIFS(Status:Status, "Under Analysis", Launch:Launch, @cell < TODAY())

For some reason if I excluded the '@cell' it didn't work, but it's all good now!

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.