# Calculating % on-time vs late delivery

edited 09/23/20

Hello,

I am trying to calculate the % of items we deliver on-time and % of items we deliver late. I have a column where I calculated the "average no. of days between due date and completion date" and a column for the team members name.

For % on-time deliveries, I think that I need to only grab the cells that have "average no. of days between due date and completion date" less than or equal to 0, for that team member. What would this formula look like?

And for % late deliveries, I think I just need to change the "less than 0" to "greater than 0".

Thanks!

• ✭✭✭✭

Try this:

On Time Deliveries

=countifs([Average No. of Days Between Due Date and Completion Date],<=0,[Team Member Column],Team Member's Name)/countif([Team Member Column],Team Member's Name)

Late Deliveries

=countifs([Average No. of Days Between Due Date and Completion Date],>0,[Team Member Column],Team Member's Name)/countif([Team Member Column],Team Member's Name)

• edited 09/23/20

Thank you!

## Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!