Date Overlapping Formula with Same Resources
I am working on a challenge below hoping for some help.
I would like to raise a flag (on a flag column), if
- Start Date and End Date of a project conflict with other Start Date and End Date. Projects are the ones with Header "0"
- Only if the Start Date and End Date of the projects are assigned to the same Project Manager
In the scenario below, Project 4 and 1 should raise a flag as they are both managed by the same project manager and fall between the same duration (Start Date).
Any help would be greatly appreciated.
Help Article Resources
Check out the Formula Handbook template!