Add up all PAST DUE Items
Comments
-
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
Help Article Resources
Categories
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!