Inventory Management System

NMart
NMart
edited 11/14/24 in Smartsheet Basics

I am looking for a way to have our maintenance team be able to manage a stock inventory on specific machine parts. I would like for them to use their phones to scan on to either the QR or barcode and it reference my sheet. From there they could update the inventory, and I would have automation set up to alert that an inventory order is needed. Is there a way to do this utilizing barcodes/QR codes? What would be the best template.

Also, keep in mind I am fairly new to Smartsheets and I dont have the knowledge base creating formulas in the program as well as I do in excel.

Answers

  • Paul.Woodward
    Paul.Woodward ✭✭✭✭

    Hello NMart.

    I wonder if this solution template would work for you! I have never used barcode scanners before but I have been using Smartsheet for almost 5 years. If I can help at all, please feel free to reach out, and I will try to assist. paul.woodward@ac-foods.com

    Asset Management | Smartsheet

    Also, Smartsheet is letting individuals test out AI features until 12/31 for free. You could always try that and get your formulas answered!

    Have a good one!