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
-
Please see link below
I would create a new sheet for last two columns which will give you totals.
Please let me know if this helps and when you are done examining the sheet so I can Delete.
Thank you
Answers
-
Good Morning
I would just use a
=sumif(range,Criterion,[sum_rage]
-
@Antonio Figueroa I don't know that I can make that function work (unless I am just missing something). Here is a snapshot of my inventory. We have hundreds of line items. Many of the materials have the same name. I need to calculate Overall total amount for that chemical by summing all the Total Available Amounts for the material of that name. Does that make sense?
-
Please see link below
I would create a new sheet for last two columns which will give you totals.
Please let me know if this helps and when you are done examining the sheet so I can Delete.
Thank you
-
Please add rows to Full Chemical name and add quantity and it will automatically update new sheet
-
Thank you @Antonio Figueroa
This is helpful. I will just need to make sure that if someone adds an entry that is new to the list, I add that material to the calculation column on the new sheet.
I think I've got it! Thank you again. Have a lovely weekend!
-
You are welcome
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.9K Get Help
- 441 Global Discussions
- 139 Industry Talk
- 472 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 68 Community Job Board
- 496 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!