I am trying to identify clashes when scheduling shows in Airtable.
I am dealing with performance groups some of which share the same members I am working with 4 tables one containing all of the ‘ensembles’ a second with all the individual members of each ensemble (Contacts) which are linked to all their ensembles. Thirdly a schedule which links each ensemble to a venue, start time and finish time.
I would like to find a formula which will flag a show as a clash if contacts are linked to multiple ensembles with the same start time?
Any help please, I am banging my head at the table…