How to manage inventory?
We have a storage room with inventory that's organized with barcodes for each item type. We are trying to have a barcode scanner that's connected to a workstation and have it interact with the smartsheet that has the record of our inventory.
The idea is to have a barcode that links to the smartsheet
Once we scan the barcode thats linked to the smartsheet we would then scan the barcode for the inventory item. When the barcode for the item is scanned we want the cell to be selected in smartsheet.
Then once that cell is selected we wanted to be able to change the quantity amount by scanning a barcode.
Is it possible to have a barcode that highlights the quantity amount cell for the item we selected and then we scan a barcode to check out a certain amount or check in a certain amount.