Production Schedule with Horizontal View

Rascal

We currently utilize excel to map out production by week, per product

Excel.JPG

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.

Worksheet.JPG

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.

Report.JPG

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

Kiela

Have you thought of creating a metric sheet that pulls this information together and will show it how you like?

Rascal

Kiela, I just thought about doing this today. Thanks for the input!