Tardy Identification System
I am able to flag down if the 'Date Completed' surpassed the 'Deadline'; however, I am unsuccessful in making a tiered tardy system: Ontime, Late (+30 days late), and Super Late (+60 days late).
=IF([Date Completed]@row - Deadline@row > 0, "LATE", IF([Date Completed]@row - Deadline@row <= 0, "ON TIME", IF([Date Completed]@row - Deadline@row < 90, "SUPER LATE")))
When I changed the 'Date Completed' to be greater than 90 days, my formula is not able to recognize this.
Help Article Resources
Check out the Formula Handbook template!