I'm developing an inventory smartsheet that keeps clothing inventory in one sheet and then a form that allows an employee to request clothing for team members. I am working if I can create a formula to deduct the quantity of each clothing apparel once it is requested. There is no approval process needed.
Smartsheet 1: Kit Inventory
Smartsheet 2: Kit Requests
Help Article Resources
Check out the Formula Handbook template!