Inventory Update Via Barcode?

S.Armstrong ✭✭
edited 07/15/22 in Smartsheet Basics

I am new so bear with me.

I am working on my Inventory process. I created a sheet that contains my inventory information. To keep up with inventory, I added a workflow that states on XXX day every month all rows that have a removal date less than XXX date, will be copied over to a new sheet named Asset Inventory. From the new sheet, I want to create a workflow to request an update from people that have inventory assigned to them. All of my inventory has unique barcodes assigned to them. Can the workflow be set up so that when the barcode is scanned that row is highlighted or a box is checked, the scan date is added, or something is done to show that the items are accounted for? I am open to suggestions. There has to be a way to authenticate the item.

Thank you!