How can I build the following relationship
I am a new ser to Smartsheet and want to figure out how to do the following:
I have built an inventory (very simple) to keep track of what we have in stock. However, I am not sure how to keep track of what is being sold. I want to create a sheet where I can input what is being sold, and have this number updated automatically in my inventory.
I am not sure how to create this, or the best way to go about this.
Any help is greatly appreciated.
Answers
-
You would set up your second sheet that has the list of everything sold and then subtract a SUMIFS on your master sheet from the starting inventory.
=[Starting Inventory]@row - SUMIFS({Units Sold}, {Item ID}, @cell = [Item ID]@row)
Come see me in Seattle at ENGAGE 2024! I will be at the 10xViz partner booth throughout as well as the "Lets Talk About Community" Meet & Eat table on Tuesday from 11:45am - 12:45pm!
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.8K Get Help
- 376 Global Discussions
- 207 Industry Talk
- 440 Announcements
- 4.5K Ideas & Feature Requests
- 139 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 284 Events
- 33 Webinars
- 7.3K Forum Archives