Calculate Overdue Documents

Anil Rattan
Anil Rattan ✭✭
edited 07/22/20 in Formulas and Functions

I have two dates columns. One is Target Completion Date and the other New Target Date.

I have the following two questions:

  1. I wanted to know how many documents did not meet the Target Completion date. Total counts.
  2. If the Target Completion Date was extended then how many documents missed the New Target Dates. Total counts.

Thanks!

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!