Inventory tracking: link items to dates and locking them out during already selected time frames.
Inventory tracking: if an item is selected in 1 column and there are check-in and check-out dates in their own separate columns, I would like the availability column linked to that item, and if the item is already booked for a date or date range that someone else is not able to select said item if any of the dates overlap.
Also would like this to work through a form and also want to approve the form request before it goes onto the sheet.
Help Article Resources
Check out the Formula Handbook template!