How do I set up an inventory management system in Smartsheet?


Hello, I'm looking for help setting up an inventory management system in Smartsheet. We have a set number of chairs, tables, linens, projectors, etc. that various departments at my organization use each day. I'm looking to create a system where they can input their daily needs, and it will show how many of each item is already booked for that day (or at least available vs. unavailable). Any ideas? I'm assuming I need to get into some more complex formulas for this one.

Thanks in advance!


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!