I'm looking to create a sheet to manage our department's inventory of swag/give-aways. I currently have the asset management template set up and running and am using the barcode functionality which is mostly serving our needs. The one gap I have is inventory updating. Ideally, when someone takes inventory, I would like for them to indicate quantity taken in one column, have the remaining quantity column be updated accordingly, and then have the quantity taken column clear for the next person. I'm using a simple formula (original quantity column-quantity taken column=quantity remaining column) and then a workflow to clear the quantity taken column. The problem being of course, as soon as the quantity taken column is clear, the formula sees that column as a zero and the remaining quantity column reverts back to the original quantity value.
Is anyone else tracking inventory in a similar way? Or have advice on a different formula/workflow to use? Thank you!
Help Article Resources
Check out the Formula Handbook template!