I am using Google Calendar to keep track of s...

[PEBSAF_Jenn]

I am using Google Calendar to keep track of seminars for each presenter. I developed an Appsheet application so the presenters can keep tract of the assigned seminars.

How do I check if two or more events have been entered in the calendar for the same presenter and for the same date.

What formula can I use to verify a double booking for the same Attendees?

Column Attendees is a LIST.

Could be more than one attendee Presenter assigned.

This is where I enter the email for the presenter and the assistant. Date:

Is the seminar date.

Help!