Flagging a double booked room
I have a tracker that my team use to manage their daily tasks. However, due to COVID there can only be a specified number of people in a room at a certain time. Often rooms have been double booked, resulting in work being delayed.
I want to highlight whether a room has been double booked on a specified date by an OTHER team, i.e. Team 1 can have multiple bookings of that room for a day (1 room might have 3-4 events against it for a day), but if Team 2 wishes to book that same room, raise a flag.
My formula is 2/3rds of the way there, just struggling on the team bit:
=IF(COUNTIFS(Room:Room, =Room@row, [Start Date]:[Start Date], =[Start Date]@row, Team:Team, <>Team@row) > 1, 1)
Is there any other way I could approach this? Thanks!
Help Article Resources
Check out the Formula Handbook template!