Live Inventory Count


I am attempting to create a sheet that can track chemical inventory based on type of chemical and container size. I would like a "live" inventory count to populate in the Qty Remaining but am struggling on figuring out the formula to use and how to set it up.

I think I needs a SUMIFS formula but am getting stuck on how to select the cells so it pulls correctly. I added an In/Out column so the formula could detect if "out" is selected the number in the "Qty" column needs to be subtracted and if "in" is selected the number in the Qty column needs to be added to the Qty Remaining column.

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!