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!
Help Article Resources
Check out the Formula Handbook template!