Flag shifts conflicts on multi-location schedule

[FlorianPhil]

Hi There,

I have been working on a multilocation (6) weekly scheduling board for 19 employees with some of them having different attributes (notary/supervisor).
I would like to make sure the same employee doesn't get schedule at two location for the same time, but sometimes, employees have two shifts in two locations on the same day.
I would like to find a way to flag a time conflict if that happens.

The employees work different shifts at different locations every week, so I created the board so that formulas automatically detect the name input in the left column.
Formulas refer to the top list of employees that can be eventually extended if new employee join, and this is also needed to detect notary/supervisor and calculate daily coverage

I wanted to attach or create a link to the file but it seems like it would be against the rules..

Hope that makes sense and that someone could help. Didn't find a way to do that yet.

Thanks !