Check for overlapping date ranges between sub tasks
Hi,
I am looking for a formula that can check for overlapping date ranges between of the sub tasks on a project.
In the screenshot below the project has several sub tasks and I need a formula that will identify any overlap between the dates on the tasks.
I would like to prevent the use of references to cell numbers because I need to copy this formula across many lines.
Would you have any suggestions on how to resolve this?
I have tried to use COLLECT and COUNTIF but it seems I cannot compare 2 ranges of child records. I can only compare 1 column to a specific cell
Thank you very much !
Comments
-
So to be clear... You are basically trying to look at the start and finish dates for Task 1 and see if there is any overlap in the dates for the other tasks, then repeat this comparison for the remaining tasks?
Are you trying to also compare Task 1 in Children Group A to dates in a separate group of Children rows, or are you only comparing within that same grouping of child rows?
Come see me in Seattle at ENGAGE 2024! I will be at the 10xViz partner booth throughout as well as the "Lets Talk About Community" Meet & Eat table on Tuesday from 11:45am - 12:45pm!
-
Hi Paul, thanks for you reply and helping out with this. Your first statement is correct.
about the second statement:
I am trying to compare the dates within the same grouping of children and not to other groups of children.
Kind regards
-
Awesome! Ok. I remember helping someone set something similar up not too long ago. I will see if I can find my notes and get back to you.
Come see me in Seattle at ENGAGE 2024! I will be at the 10xViz partner booth throughout as well as the "Lets Talk About Community" Meet & Eat table on Tuesday from 11:45am - 12:45pm!
-
Hello, I have the same question and condition as Bas, would like to know if we can calculate how many days are overlapping between Child task date range. And similarly, if that calculation can also help to count how many days are not overlapping from the child task date range as well. Thank you!
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.9K Get Help
- 379 Global Discussions
- 211 Industry Talk
- 441 Announcements
- 4.6K Ideas & Feature Requests
- 140 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 301 Events
- 33 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!