Hello, I noticed when the duration column for GANTT view is assigned, it does not automatically calculate the duration for the task so I created another column to calculate the duration using a formula;
This gets me the correct number of days to display for the calculated duration.
Then I created an automation that when this column is updated, the GANTT duration column is changed to this number. The automation works except for one issue I do not know how to fix. The GANTT column is displaying numbers 1 higher than my calculated duration it is supposed to mirror. To counter this I tried the formula;
I thought since it is displaying one higher than the value I calculate, subtracting 1 should fix it, but the result was my calculated duration changed as expected but the GANTT duration did not and was now displaying 2 higher. It only seems to take the duration between the two dates and include the start date as a day but I really want it to not include the start day. So if a task is due tomorrow, I want it to say 1 day for duration instead of 2. Is this a bug? Or is the GANTT duration column meant to only count the days between the dates including the start date? And if that is the case, why didn’t it automatically populate without me copying values from another column?