Help

Upcoming database upgrades. Airtable functionality will be reduced for ~15 minutes at 06:00 UTC on Feb. 4 / 10:00 pm PT on Feb. 3. Learn more here

Find overlap in Airtable

Topic Labels: Formulas
381 1
cancel
Showing results for 
Search instead for 
Did you mean: 

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.