Manufacturing Production Report

karawelcome

Hello,

I work for a relatively small manufacturing company where our production managers meet every single morning, give their production numbers, headcount, etc to the manufacturing managers for them to enter the data manually in excel every morning.

We created a form in Smartsheet for the production managers to enter their data every morning but now we are struggling to get the report to generate correctly. We need it to do a daily headcount percentage, weekly and monthly production numbers and headcount percentage, and year to date numbers.

Paul Newcome

I would suggest a separate sheet with formulas using cross sheet references to do your calculations.