nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Smartsheet Community

Connect with peers, share your expertise, and inspire what’s next in Smartsheet — from proven practices to practical how-to insights from fellow users and product experts.

Welcome!

Counting Past Due

bmcmichael48661

I am trying to count anything that is a past due task, but not counting items that are closed. What is the best formula to use?

My current formula:

=COUNTIF(Due:Due, <TODAY(1))

BUT this is counting all items that are due past TODAY. Any pointers?

Find more posts tagged with

Formulas

Comments

Mike Wilday

=COUNTIFS(Due:Due, <TODAY(1), Status:Status, <>"Complete")

That is assuming your status column is labeled Status and its not a checkbox column. If it is a checkbox column, try

=COUNTIFS(Due:Due, <TODAY(1), Status:Status, 0)

bmcmichael48661

Mike-

It is not supposed to count anything that is closed, lesson learned, or duplicate.

The current formula is:

=COUNTIFS(Due:Due, <TODAY(), Disposition:Disposition, <>"Complete")

This formula is counting those things, however, I need to count anything that is passed due and not closed, lesson learned or duplicate.

Thoughts?

Branden

J. Craig Williams

Sign in to join the conversation!

Quick Links

Trending discussions

Filtering Formulas
The below formula should give me the total price of a project filtering it by the panel name and the area. I do not want to include a certain supplier. Also Level 1 is totalling the child rows, so I want to filter that out as it give an inaccurate overall total of the price allocated to the panel and area. I can't figure…
Filtering Graphs in Dashboards
I've created a dashboard with multiple graphs using data from the same report. I have added the report to the dashboard as well and set up the filter for use in the dashboard. Is this filter transferable to the graphs as well, given i can filter the report in the dashboard?
Automation Error: Adding Rows to Destination Sheet with Same Name System Columns
I have an automation that runs every morning at 5:00 am ET that copies a row from one sheet to another sheet. I received this error in the Action block in the source sheet: Rows can't be added to the destination sheet because a column has the same name as a system column on the source sheet. Originally, I had a system Auto…