Inventory

Michael Payment

I am new to Smartsheet and trying to setup an Inventory Management system. We are a gravel and construction company that has multiple products in multiple pits. I am looking for the best way to setup a sheet that uses a form the operators can fill in that would populate the data sheet. Then I think I would need another master sheet that would pull the info from the data sheet to give me a live running inventory system. Not sure if this is something that can be done or not.

Andrée Starå

Hi @Michael Payment

Smartsheet would be perfect for this use-case.

Here are some templates that could work or be an excellent starting point.

https://www.smartsheet.com/marketplace/template-set/workforce-ppe-inventory-management

https://www.smartsheet.com/marketplace/template-set/ppe-inventory-tracking

https://www.smartsheet.com/marketplace/templates/barcode-inventory-management

https://www.smartsheet.com/marketplace/templates/inventory-management

https://www.smartsheet.com/marketplace/templates/inventory-stock-control

Would any of those options work/help?

I hope that helps!

Let me know if I can help in any way!

Be safe and have a fantastic week!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!

Linsie Weatherford

@Andrée Starå have you had any issues with smartsheet not finding the barcode? I have entered multiple barcodes into Smartsheet and no luck when I use my app to "search" for the barcode. I even tried it with your "Barcode Inventory" template. I scan the barcode with the SS search feature on my iphone, and it keeps saying "no results." I have made sure there are not any filters in my search. App is also up to date.