I have a use case where I am using sub-tasks to track progress of specific activities and then roll this up into the main task.
Each sub-task has a Start Date/End Date that we enter.
At the task level, I want to be able to identify the ‘earliest start date’ (i.e. when did the first sub-task commence).
To this, I then want to add a specific estimate (which is a number field at a Task level - e.g. 7 days) - to then calculate an ‘Expected Due Date’.
I can see on the Sub-Task you can right click to select an option to report this at a task level, but it will give you a range of dates based on the different dates the sub-tasks show. From this, i want to use a formula to calculate the earliest start date.
I tried using a column at the Task level to assign a Function and use the MIN function, but this doesn’t seem to return a valid value.
Has anyone got a similar use case they can provide some guidance from or suggest an alternative approach ?
Thanks