Identifying clashes using linked feilds


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…

This topic was solved and automatically closed 15 days after the last reply. New replies are no longer allowed.