Double Booking Dates

I am looking for some help on a meeting calendar for double booking the same date and time. I currently have it set up with this formula

=IF(COUNTIFS(Date:Date, Date@row, [Start Time]:[Start Time], [Start Time]@row, [End Time]:[End Time], [End Time]@row) > 1, 1)

This works for activating the flag in the column of the sheet. The problem I am having is that this will flag both entries that are the same and not just the 2nd booking. I have a Conditional Formatting on this to send an Update Request to the recipient of the "Flagged" column. Again, this will send to both of the recipients that are double booked for that date and time.

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!