Calculate % on time deliveries for team

Camilla Sugiarta

Hi,

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?

Thanks!

Genevieve P.

Hi @Camilla Sugiarta

This will depend a bit on how your sheet is set up, but essentially you could count the number of tasks that are less-than-or-equal-to-1 (as you have above, but without the Reviewer criteria), then divide this by the total number of tasks, counting perhaps the non-blank cells in your primary column?

Try This:

=COUNTIF([Work Days Between Due date and Date sent]:[Work Days Between Due date and Date sent], <=1) / COUNT([Primary Column]:[Primary Column])

If this doesn't work, it would be helpful to see a screen capture of how your sheet is set up, but please block out any sensitive data.

Cheers!

Genevieve

Genevieve P.

Hi @Camilla Sugiarta

This will depend a bit on how your sheet is set up, but essentially you could count the number of tasks that are less-than-or-equal-to-1 (as you have above, but without the Reviewer criteria), then divide this by the total number of tasks, counting perhaps the non-blank cells in your primary column?

Try This:

=COUNTIF([Work Days Between Due date and Date sent]:[Work Days Between Due date and Date sent], <=1) / COUNT([Primary Column]:[Primary Column])

If this doesn't work, it would be helpful to see a screen capture of how your sheet is set up, but please block out any sensitive data.

Cheers!

Genevieve

Camilla Sugiarta

It works! Thanks Genevieve!

Genevieve P.

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