Introducing Formula Custom Fields!

It’s good to see that when creating a formula for (due date) minus (start date) the value is in days (and hours if a start/end time is added).

However, for a task that runs for a week, Monday to Friday, for example 3rd July until 7th July (5 days), the value unfortunately returns as 4 days. All the values from the formula are 1 day less which in turn provides an inaccurate SUM (albeit in weeks & days instead of just days). So a task that is to be completed in a day, returns a blank value, instead of 1d.

@Nao_Kumazaki , is this something the product team is looking to address? Or could they explain the logic behind this function (of values showing 1 day less than they should).

4 Likes