Production Schedule with Horizontal View

We currently utilize excel to map out production by week, per product
I would like to utilize Smartsheet, below is a sample of data entered in a Smartsheet Worksheet/Grid. PO's may be for multiple quantities, same part number (haven't looked at grouping as child rows yet), or mulitiple part numbers on one PO.
I can group by Year/Week and create a report with a vertical view, sample below, but this does not give production the visibility they would like to see.
Before I dig in to this too deeply....If I create columns with week numbers, can I get similar results? The worksheet displays just a few of the columns/information I need to capture.
Any response is GREATLY APPRECIATED
Answers
-
Have you thought of creating a metric sheet that pulls this information together and will show it how you like?
-
Kiela, I just thought about doing this today. Thanks for the input!
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 66.2K Get Help
- 430 Global Discussions
- 152 Industry Talk
- 490 Announcements
- 5.2K Ideas & Feature Requests
- 85 Brandfolder
- 154 Just for fun
- 75 Community Job Board
- 502 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 306 Events
- 36 Webinars
- 7.3K Forum Archives