Time tracking exceeds time estimated
Z
Zoe Pedersen
URGENTLY need some solution to flag/alert for if a task goes over it's estimated time i.e if time tracked exceeds time estimated
Log In
Activity Feed
Sort by
Philipp Wichmann
I guess this should be merged with https://clickup.canny.io/feature-requests/p/automation-for-when-time-tracked-exceeds-time-estimated
Maria B.
This is my concern as well as it won't alert managers like me when some members exceed billable hours
Aus Alkhatib
I guess you can use the calculated field and write formula to check the condition
M
Melanie von Schorlemer
I fully agree! There must be an alert to the project manager because this creates overtime, impacts the teams' capacity because work has to be shifted and more time on a task exceeds the budget.
Truc Thi Thanh Tran
Would love to get a progress bar for this where it would show the percentage of time completed in percentage.
Erin Hoffarth
This would be a nice out of the box item. As a workaround, I have setup a formula custom field that subtracts the time estimate and the time tracked and adds a tag when this get to a negative. I bet you could set it to be a threshold tag as well. Just an idea in the meantime.
pixojoy
Erin Hoffarth: Thanks for sharing this. Would you be willing to screenshot the formula and share it here? I'm curious what that looks like
Truc Thi Thanh Tran
pixojoy: I did something similar to create a formula which show different status as such:
If (time tracked/time estimated) < 100%, status is Green
if (time tracked/time estimated) < 115%, status is yellow
if (time tracked/time estimated) > 115%, status is Red
Formula:
if(field("Time tracked in hours") / field("Time estimated in hours") <= 1, "🟢",
if(AND(field("Time tracked in hours")/field("Time estimated in hours") > 1, field("Time tracked in hours")/field("Time estimated in hours")<1.15), "🟡","🔴"))
Erin Hoffarth
pixojoy: Here is the formula I use (15 minute increments): ROUND(field("Time estimated in hours")-field("Time tracked in hours"),15,"m")
pixojoy
Erin Hoffarth: Truc Thi Thanh Tran: Thank you both for sharing these formulas, you rock
Paul Dittus
100% it would be great to have a progress bar to quickly see how much of the estimated time has been used already.
E
Erin Tripp
Yes please! I would love an alert when time tracked hits 80% or 90% of the time estimate too!
Nibal Catalan
very reasonable and useful for KPIs.
Natalie
I agree
Load More
→