Keeping count…in three different places
I hope I’m asking this question right…here we go. I’m attempting to create an inventory log where users can add or transfer items from and to one of three locations. The problem I’m running into is this:
- The amount of items that can be added or transferred between sites are numerous and I’m trying to think of the most efficient way to show those numbers. So for instance. We have 3 items at location one and need to move 1 of them to location two. What’s the best way to reflect the change in inventory at location one (-1) and location two (+1)?
Answers
-
Hi @Cristina Ruston
Hope you are fine, you can create 3 sheets each one represent one of your sites and you can create main summary sheets for counting and monitoring.
bassam.khalil2009@gmail.com
☑️ Are you satisfied with my answer to your question? Please help the Community by marking it as an ( Accepted Answer), and I will be grateful for your "Vote Up" or "Insightful"
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 65.9K Get Help
- 429 Global Discussions
- 147 Industry Talk
- 487 Announcements
- 5.2K Ideas & Feature Requests
- 86 Brandfolder
- 151 Just for fun
- 74 Community Job Board
- 497 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 305 Events
- 36 Webinars
- 7.3K Forum Archives
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!