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.

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

    Join us at Smartsheet ENGAGE 2024 🎉
    October 8 - 10, Seattle, WA | Register now

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!