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!
