Milestone OTIF metric
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
-
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 <> "")
Come see me in Seattle at ENGAGE 2024! I will be at the 10xViz partner booth throughout as well as the "Lets Talk About Community" Meet & Eat table on Tuesday from 11:45am - 12:45pm!
Answers
-
Do you have a date column for the target completion and another date column for the actual completion?
Come see me in Seattle at ENGAGE 2024! I will be at the 10xViz partner booth throughout as well as the "Lets Talk About Community" Meet & Eat table on Tuesday from 11:45am - 12:45pm!
-
Yes sir
-
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 <> "")
Come see me in Seattle at ENGAGE 2024! I will be at the 10xViz partner booth throughout as well as the "Lets Talk About Community" Meet & Eat table on Tuesday from 11:45am - 12:45pm!
-
Would you use the following to find the % On Time for Milestones (MR) only
=COUNTIFS([Helper Column]:[Helper Column], @cell = "On Time") / COUNTIFS([Helper Column]:[Helper Column], @cell <> "") AND COUNTIFS([MR]:[MR], @cell = "TRUE"
-
You would include that range/criteria set in both of the already existing COUNTIFS. You would not use a third COUNTIFS.
Come see me in Seattle at ENGAGE 2024! I will be at the 10xViz partner booth throughout as well as the "Lets Talk About Community" Meet & Eat table on Tuesday from 11:45am - 12:45pm!
-
You are AWESOME thank you
-
Happy to help. 👍️
Come see me in Seattle at ENGAGE 2024! I will be at the 10xViz partner booth throughout as well as the "Lets Talk About Community" Meet & Eat table on Tuesday from 11:45am - 12:45pm!
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.8K Get Help
- 376 Global Discussions
- 207 Industry Talk
- 438 Announcements
- 4.5K Ideas & Feature Requests
- 139 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 451 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 282 Events
- 32 Webinars
- 7.3K Forum Archives
