We have 7 manufacturing lines, each with their own sheet for tracking line metrics. Each line needs a dashboard. Is it possible to share a common dashboard across the lines. I don't want to maintain 7 separate identical dashboards.
Badges!?! We don't need not stinking badges!
Yeah you can do this. Just point your dashboard to the right metrics sheets.
Smartsheet Tips and Tricks for Beginners and Advanced on LinkedIn and YouTube
Come Say Hello!
If I understand you correctly, you are saying to change the sheet reference, but isn't that only in the development environment? These dashboards are to be used by Sr. managers. They will want to have one dashboard and be able to "point" it to the specific line's sheet on-the-fly. Maybe a dropdown box with the line sheet names to select from?
NOTE: This is my first day using SS, so please excuse my ignorance.
If I'm understanding you correctly, you'd like to have one Dashboard that's dynamic so whoever is looking at it can select what Project they want to see data for and have it automatically adjust to bring in the correct information. If so, this is currently not possible in Smartsheet Dashboards, but please do add your vote and voice to this Product Idea thread!
In the meantime, you would need to create 7 separate Dashboards, each looking at their own Project sheets. I would recommend having one top-level "overview" Dashboard across all projects, then you can use an Image Widget to link out to the individual Dashboards (perhaps with an image on the individual Dashboard that says "Back" which links to the overview one).
You could also just have one Dashboard with many sections (different headers) and duplicate data. You can use copy/paste across Dashboards to duplicate widgets, or Save as New to copy an entire Dashboard (then update the source data for each widget).
@BlazorSaddles I second @Genevieve P. suggestions!
Hello! I copied a form I had made for a similar event I am working on now. I made minor adjustments to the form to match the needs of the event. I distributed the form for people to complete, so the form is active, but the data is not populating onto my Smartsheet. Please advise. I would prefer not to have people redo the…
Hello. Trying to make a quick attendance tracker for a meeting. I got conditional formatting to change the cell color when its checked vs unchecked. However I cannot seem to find a way to get the rule to apply to multiple columns on a per column basis. I need a way to copy what I have for column 3 and apply it to all…
Hey Smart Heads, I have another question about our beloved topic of formulas. Background: I have a autogerated column with row created date. In the file, rows are added in 2 ways: In bulk, by senior auditor Ad-hock by auditor I would like to diferentiate these two types of inflow. I came up with an idea of finding…
Help shape the future of Smartsheet.
Share your ideas and feature requests.
©2023. All Rights Reserved Smartsheet Inc.