Count cumulative working days for same task with or without date overlaps
Dear Smartsheet Pros,
I would like to return the sum of the total number of working days for a specific Task Type when there may or may not be overlapping activities for different tasks of the same Task Type, but not count the overlapping work days. Ultimately, I would like to return the sum for each Task Type (there are 9 total) in a separate "roll-up" sheet for each Task Type or in a report (if this is possible). I have been only able to manually calculate this.
The attached provides an example from a grid/sheet for one of the Task Types "2 - Task B". The section identified for Task B.3 (4/11-4/22) has dates which overlap with Task B.2 which I would like to exclude from the total days worked sum formula. So, instead of the duration being 59 days, it would be 42 working days (14+18+10).
Thank you for your assistance!