Welcome to the New Smartsheet Online Community
You’ll notice that things have changed a bit. If you need help getting oriented, please take a look at the posts here in the Welcome to the Community category.
Automatically Track Inventory Usage
I'm new to smartsheets and am not an excel expert, but I've been building some sheets and workflows and have a question about more advanced capabilities of the program.
I'm hoping there's a way to automatically track inventory usage based on information input into a separate smartsheet form? I have two sheets: one is the inventory list, and one is related to outgoing inventory items. I'm wanting to include the items from the inventory list on the outgoing inventory form and when users "order" an item through the form, have it deduct from the quantity noted in the inventory sheet automatically.
Can someone let me know A) if this is possible; and how to do it? Thank-you!