Find overlap in Airtable

Hi,

I have a base I use to request rooms. Is there a formula I can write to let me know if there is overlap in a request?

For example:
1/10/2022: I have a request for 4 large conference rooms for Group 1 from 10-12
1/10/2022: I have a request for 3 medium conference rooms for Group 2 from 1-5
1/10/2022: I have a request for 2 large conference rooms for Group 3 from 9-11

I need a column that will show me that there is overlap with the request for Group 1 and 3, but that Group 2 has no overlap. Knowing which sessions have overlap, I can adjust the schedule, or room types, to ensure rooms are assigned correctly.

Any suggestions?

Thanks!
Jeffrey

Formulas aren’t robust enough to allow for this kind of overlap prevention. A script could do the job, but writing one would take some time. Thankfully @Kamille_Parks has already taken care of that. Look into the Scheduler app, which is designed just for this use case.

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