Hello!
Here is what I am trying to create:
A formula that results in telling me if the same collaborator's scheduled leave is going to conjunct with another collaborator in the same team.
This is what I am working with:
- leave start date
- leave end date
- Team Slack ID which is a lookup field directly connected to the collaborator selection eg. if Mary JONES selects her name, the Slack ID for her teams HR and Marketing will show.
I am trying to build a formula that will:
- be able to identify conjunction between leave periods.
- search if this conjunction is happening between collaborators who work in the same team.
Has anyone some ideas to share?