Barcode or QR Code Auto-Adjust Inventory

TylerZ

Hello,

Is there a way in SmartSheet that I can have the staff in our clinic scan a barcode or QR code for one of our consumables and have the inventory AUTOMATICALLY adjust down 1? I know it is possible to scan a barcode and then edit the cells automatically but this has it's own problems.

The issue I need to eliminate is staff having to do math when removing inventory. I solved this in Excel by creating a macro. Three columns. Current, Adjustment, New. The staff enter the adjustment value (i.e. I took 3 syringes) and then clicks the button and it copies the new values into the current inventory as a new baseline qty on hand.

I prefer to use SmartSheet because I have an automation to copy the row every time it is adjusted in order to create usage reports.

Thanks,

Tyler

Paul Newcome

How do you currently have your Smartsheet structured?

LeighAnnW

I could really use an answer to this question. Here's what my sheet looks like.

Paul Newcome

@LeighAnnW Which numbers would you want to adjust and how?

LeighAnnW

@Paul Newcome I would like to have it so that when someone scans the barcode, the QTY USED column add 1 per scan. This way we can see how many of each product is being taken out.

Paul Newcome

@LeighAnnW If it is strictly 1 per scan, you would use a COUNTIFS to find out how many rows contain that particular barcode and then subtract that from the starting inventory.

LeighAnnW

@Paul Newcome Each barcode is specific to the row it's on. Would that still work?

Paul Newcome

@LeighAnnW How would you know which qty to subtract it from then?

LeighAnnW

I want to subtract from the column that is labeled QTY every time the barcode is scanned.

Paul Newcome

Right, but how do we know which previous QTY to subtract from if each barcode is different?

Or is your screenshot of the reference sheet and your scanned barcodes/form entries would be on a different sheet?