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!
I don't use COUNTIF, only COUNTIFS
column references are like this:
[Column Name]:[Column Name]
=COUNTIFS(date-column, @cell < TODAY())
should get you started.
©2022. All Rights Reserved Smartsheet Inc.