Count if date is in the past

Hi All,

I am looking for a solution to a problem, I am trying to pull together a chart for a dashboard, displaying the number of overdue documents under review we have - the sheet is set up as below, and I have set up a 'metric sheet' however I am not sure this is the best solution. I have been using this =COUNTIFS({Master Document Tracker [DO NOT DELETE] Range 3}, <=TODAY()). But i have quickly realised, if there is an over due date in this column there will potentially be one in each column for this row. how do I count if any cells within a row have overdue dates but eliminate duplicate counts within the same row.

all suggestions welcome! thank you in advance!

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!