Counting # of Overdue


Hi, I am trying to count the number of Overdue rows using two deadline columns (Due Date 1, Due Date 2) and a Status column, so using both of these criteria:

  1. Determine if the deadline has passed from the earlier of the two deadlines
  2. Eliminate from the count any past due rows also marked as Completed in the Status column (this column is a dropdown)

Some of the cells in either Due Date column may be blank (those should just be ignored for this purpose).

Could build this in either the metrics sheet or the sheet summary.



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!