How can I build the following relationship
bitzy24
✭
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)
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.8K Get Help
- 434 Global Discussions
- 138 Industry Talk
- 470 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 65 Community Job Board
- 486 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives