Production Data Report

I am looking for help on setting up a dashboard of sorts to summarize monthly production data.

What I have now in excel is that I can select a month from a drop down menu, and then the data fills into several tables I have made based on the selected month. Is there a way to have a similar setup within smart sheets?

I attached a picture of what I have in excel below.

Thanks.

Find more posts tagged with

Manufacturing

IT & Operations

Comments

Andrée Starå

Hi Nick,

There are a few different ways to set this up.

One way to do it would be to have a drop-down on the sheet where you choose which month it is that you want to show.

Another way would be to have a dashboard showing the overall information and then link to dashboards for all the months. Reports could also be a possible solution.

I'd happily work with you and help you with setting up a solution.

There are a few different ways to do this, and I need some more information to see what would work best for your particular situation.

If you'd like we can book a time for a free discovery call. How does that sound?

Please e-mail me at andree@getdone.se and well take it from there.

I hope this helps you!

Best,

Andrée Starå - Workflow Consultant / Get Done

Sign in to join the conversation!

Quick Links

Trending discussions

Mr
hi would like to create a simple patient tracking system for our small clinic where i can record the time & duration a patient appeared in our establishment. Using a central sheet where it records all the data to be accessible by the admin. There will also be Four (4) forms to be accessible by the three department. Concept…
Forms
On the App - "In Smartsheet forms, is there a way to capture or upload an image directly into a specific column cell (per row) without using the Attachments field? I need each section of the form to have its own dedicated image, not just general attachments for the row."
Smartsheet Mobilizer Kit2/Best Practices
Hi - I am launching Smartsheet sessions at my organization for the next 3 months. The SS Mobilizer Kit2 Workspace I saved a few years back, the files are not loading. Is there a new resource kit? Also, I am writing up some best practices for our users: Examples: Names, separate first and last name into two columns. Email…