Check for overlapping date ranges between sub tasks

Options
Bas H
Bas H ✭✭
edited 12/09/19 in Formulas and Functions

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 !

Annotation 2019-08-21 165739.png

Comments

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!