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!

 

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