Is it possible to disable the scheduling conflict detection (red line above task on Gantt chart) when the status of said task is 'Done' ?
I am using the following formula to calculate the Fix Duration for each task:
IF(status = "Done", timespent / 3600000, IF(timespent = 0, originalestimate / 3600000, (timespent + remainingestimate) / 3600000))
This enables me to see the length of a task based on the original estimate or time remaining if time has been logged. But it will then only show the timespent if the task is done. This allows me to see how ahead or behind schedule the tasks are from a baseline.
The only issue I am facing is that when a task is shortened because it has less time logged than the original estimate but it is done, the task is highlighted as a conflict (see below). Is there a way I can avoid this happening on Done tasks?
This task has an original estimate of 10hrs and a timespent of 5hrs and a status of 'Done'. The formula has done the correct thing and set the fixed duration to 5hrs but because the original estimate is 10hrs it is showing as a conflict.
Thank you
Hello @Joe Milner-Smith
There is no customizing the conflict indication behavior - the scheduling conflict is either there or not. But you can change the configuration of the chart and the logic behind the estimates/fix duration. For example, instead of using the Original estimate value as work estimate, you can use the same formula as you do for fix duration. This way they will always match. Or insert another formula to ensure that when a task is 'Done' there is no conflict between the estimate/duration values.
I hope this helps. If you have other question - please reach out to us directly at our support portal and we'll get back to you shortly.
Best regards,
Stepan Kholodov
Tempo
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.