Milestone OTIF metric

Angie Saunders PMP
edited 12/11/23 in Smartsheet Basics

I've been given a new KPI of on time and in full (two different mesurables) for project milestones and I'm not sure how to best track the "on time" part of the milestones. How would you figure the % of milestones that are hit on time? It feels like it would need to be very manual.

Best Answer

  • Paul Newcome
    Paul Newcome ✭✭✭✭✭✭
    Answer ✓

    In that case, you would use a helper column (can be hidden after setting up) with a formula that indicates whether it was on time or late.

    =IF([Actual Date]@row <> "", IF([Actual Date]@row<= [Target Date]@row, "On Time", "Late"))

    Then to get the percentage that are "On Time" you would use

    =COUNTIFS([Helper Column]:[Helper Column], @cell = "On Time") / COUNTIFS([Helper Column]:[Helper Column], @cell <> "")