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

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!