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

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!