Structure.Gantt - disable scheduling conflict detection when a task is 'Done'

Joe Milner-Smith August 1, 2023

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

1 answer

0 votes
Stepan Kholodov _Tempo_
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
November 7, 2023

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

Suggest an answer

Log in or Sign up to answer
AUG Leaders

Atlassian Community Events