Calculate % on time deliveries for team
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!
Best Answer
-
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
Need more information? π | Help and Learning Center
γγγ«γ‘γ― (Konnichiwa), Hallo, Hola, Bonjour, OlΓ‘, Ciao!π | Global Discussions
Answers
-
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
Need more information? π | Help and Learning Center
γγγ«γ‘γ― (Konnichiwa), Hallo, Hola, Bonjour, OlΓ‘, Ciao!π | Global Discussions
-
It works! Thanks Genevieve!
-
That's great to hear! I'm glad it worked for you π
Need more information? π | Help and Learning Center
γγγ«γ‘γ― (Konnichiwa), Hallo, Hola, Bonjour, OlΓ‘, Ciao!π | Global Discussions
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 67.9K Get Help
- 474 Global Discussions
- 207 Use Cases
- 517 Announcements
- 5.5K Ideas & Feature Requests
- 87 Brandfolder
- 157 Just for fun
- 83 Community Job Board
- 521 Show & Tell
- 36 Member Spotlight
- 3 SmartStories
- 309 Events
- 37 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!