smartsheet for Inventory Management


We have set up a basic inventory management sheet within smartsheet to better track our inventory. So far it's pretty basic, but hoping to expand. One issue I haven't found a solution for is automating the counts when we add or remove inventory from stock. I have a "Quantity on Hand" (QOH) column that we are currently manually updating.

Ideally, I would like to create some type of automation that calculates the current QOH based on entries to a "Quantity Added" and "Quantity Removed" Column... without having a column for each time inventory is added or removed. Or without having to create a new row each time.

Ultimately we may have to move to an actual inventory management program, but would like to explore ss as an opportunity given the simplicity of what we're trying to accomplish. Any thoughts on this topic would be greatly appreciated!