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.