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

How to Track Room Utilization By Date?

Topic Labels: Formulas
168 0
Showing results for 
Search instead for 
Did you mean: 

I have a base now where I track events and rooms the events occur in (not that I’m doing much of this during coronavirus).

Each event is given a start date and end date. Usually 1 or 2 days. Each event is also tagged to a Room. Like say Room 1 or Room 2.

What I’d like to do is essentially track room utilization over the quarter. So if I have 4 events, and each one lasts two days (so the start date is say 1/1/20 and the end date is 1/2/20) and each is tagged to a room, how would I craft a formula to total up the days per room?

0 Replies 0