Add to Existing Inventory


Good morning gurus! Here is our question of the week!

I have an existing inventory of materials built into Smartsheet. Works beautifully so no problems there.

What I would like to do is update the inventory by adding either a new line item or entering the information via form. For example: If I have 3kg of material XYZ in the existing inventory and I want to add another bottle of 2kg of XYZ, is there a way to automatically update the total amount to 5kg when a line item is moved over or a an entry is made via form?

I can't seem to wrap my mind around a formula or automation that would accomplish this, so I bring it before the gurus. Any suggestions are appreciated. Thanks!

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!