Help

The Community will be temporarily unavailable starting on Friday February 28. We’ll be back as soon as we can! To learn more, check out our Announcements blog post.

Find overlap in Airtable

Topic Labels: Formulas
1448 1
cancel
Showing results for 
Search instead for 
Did you mean: 
Jeffrey_Brandt
6 - Interface Innovator
6 - Interface Innovator

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

1 Reply 1

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.