Barcode scan and update columns on line
Is it possible to scan a barcode-find the line where the barcode is already on and then put a check mark in to update the status of the line?
Basically I am scanning a a product into the Smartsheet. It will create a line in Smartsheet that has the barcode scan and then a date. Later in the process I will be scanning the barcode again and would like to automatically update the status as consumed. Either with a check box or a date. After a while I will be scanning the barcode again as it leaves the building. It will also need to update the line with a checkbox or a date.
Does this sound like it is possible in smartsheet and how would I go about creating this?