How to link totals of parts
Hi
I have a question on a formula I am not being able to work out.
I have 2 sheets (Screen shots attached):
Sheet #1 has PO Stock Material and is linked to sheet that have material usage. This sheet shows me for each PO how much was order and what I have left.
Sheet #2 is Total Material Stock. On this sheet I want to show the total stock left and what was used per part #.
The question is how to work this formula. We have the same part number on several POs. So what I want the Total material stock to show is the total of each part taking into account the finish and the length, since some parts have different finish or length
. Please help me out with this one.
Thanks a lot
Nick
Answers
-
What about using a Report instead of a Sheet? You can filter out the blank Parent rows and then Group by a unique value (perhaps the "item" column?) and SUM the Total column to find out how much is left.
If a Report won't work for you, then the second sheet will need to have an identifier for each row so the formula can bring back data from your other sheet (again, perhaps the "item" column if it's unique to that part). Let me know if this makes sense!
Cheers,
Genevieve
Need more help? 👀 | Help and Learning Center
こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao! 👋 | Global Discussions
Help Article Resources
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
Check out the Formula Handbook template!