Calculate % on time deliveries for team


I was able to use the following formula to count the % of on-time deliveries per team member.

=COUNTIFS([Work Days Between Due date and Date sent]:[Work Days Between Due date and Date sent], <=1, Reviewer:Reviewer, "ABC") / COUNTIF(Reviewer:Reviewer, "ABC")

We have several team members, so what formula could I use to calculate the % of on-time deliveries for all of the reviewers?


Best Answer


  • It works! Thanks Genevieve!

  • Genevieve P.
    Genevieve P. Employee Admin

    That's great to hear! I'm glad it worked for you 🙂

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!