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; } } }

Welcome!

Add up all PAST DUE Items

Christen Uber

I would like to add up all the action items on my Action Item log that are Past Due so I can show this on my project dashboard. How do I construct the COUNTIF statement to achieve this?

Thank you from the newbie!

Find more posts tagged with

Formulas

Dashboards

Project Management

Comments

J. Craig Williams

I don't use COUNTIF, only COUNTIFS

https://help.smartsheet.com/function/countifs

column references are like this:

[Column Name]:[Column Name]

something like

=COUNTIFS(date-column, @cell < TODAY())

should get you started.

Craig

Sign in to join the conversation!

Quick Links

Trending discussions

working with multiple due/done dates
I have a sheet that has 20 cells that are dates Due and Done for 10 categories. I have an Overdue Week column that I want to show "Yes" if a Due date is prior to current week. I managed to do that, but once one date leads to a "Yes" it never changes even if the task is completed and marked in the corresponding Done cell.…
Additional Criteria changes result
Hi folks, I'm struggling with a formula that should be simple. When the formula is this, it works great for one of two Types. The second type pulls the wrong Billing Annual Fee. =IFERROR(INDEX(COLLECT({Billing Annual Fee}, {Segment}, Segment@row, {Billing Ownership}, [Billing Ownership]@row), 1), 0) When I modify the…
Display Attachment Names in a Column
Hi everyone, Is there a way to display the attachment name(s) in a column?