Milestone OTIF metric
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 <> "")
Answers
-
Do you have a date column for the target completion and another date column for the actual completion?
-
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 <> "")
-
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.
-
You are AWESOME thank you
-
Happy to help. 👍️
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.1K Get Help
- 380 Global Discussions
- 212 Industry Talk
- 444 Announcements
- 4.6K Ideas & Feature Requests
- 140 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 450 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 290 Events
- 35 Webinars
- 7.3K Forum Archives