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
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
-
It works! Thanks Genevieve!
-
That's great to hear! I'm glad it worked for you 🙂
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.4K Get Help
- 394 Global Discussions
- 213 Industry Talk
- 449 Announcements
- 4.6K Ideas & Feature Requests
- 141 Brandfolder
- 132 Just for fun
- 131 Community Job Board
- 453 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 293 Events
- 35 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!