-
How to create a Trendline in the Dashboard
Hello Smartsheet Community! So I am trying to create a trend line that shows the # of projects in flight each month since the beginning of 2024 (YTD) and since this same month last year (YOY). The problem I'm running into is that I'm creating a report of the data listing only the project names & the dates, but the…
-
Duplicate Rich Text Widgets to another dashboard
Hi, We have a project that has a SS dashboard with all the updates ("Master Dashboard"). We have another dashboard that would duplicate some of the RT widgets from the Master Dashboard. How can we do this automatically? Trying to avoid duplicated efforts for the same exact content. The content has some rich formatting, so…
-
Metric Widget not working with specific Grid Sheet
I have a grid sheet that contains contact information. I am trying to pull that information into a dashboard focused on specific staff. The plan was to use a metric widget to pull the contact information for that individual (i.e., Name, Phone Number, Email, etc.). When I add a metric widget and try to link to this grid, I…
-
Line Charts in Dashboard not displaying data - requires save to display?
I've built numerous dashboards and have never encountered this error previously. i have a formula: =AVG(COLLECT({Material Requests (Draft) Range 10}, {Material Requests Range 1}, "1", {Material Requests Range 2}, "2024", {Material Requests (Draft) Range 3}, "Central")) This results a figure (0.39) and when I go to chart…
-
Is there a way to utilize one sheet for multiple projects, but still roll up into a dashboard?
I work in an IT department as part of a fairly large school district. We typically don't super fancy PM tools other than a project name, all the tasks associated with that project, who is doing those tasks, and when they need to be completed. So each division in our department has setup their own sheet which as multiple…
-
Add Work Insights to Dashboards
I am trying to add summary charts to a dashboard, however it requires numerical values which are impossible to add for what I am trying to show in the chart. Excel can easily create a variety of charts to show me how many cells in a column show specific data, and the Work Insight in Smartsheet also shows me the data in the…
-
Building a Dashboard off of my Status column
So I am want to build a dashboard that will track/show how many complete, not started, and in progress tasks I have. I have four separate sheets that I will be doing this with. Each having about 8-12 tasks that will be tracked. The problem is which I will share below is under each "Task" I have a Indent where committees…
-
Can a metric widget be a hyperlink on a dashboard?
I have a dashboard where I am trying to include a metric widget that captures a hyperlink from a cell on a metadata sheet. The hyperlink is to a SharePoint document. The link does not carry over to the dashboard widget. Only the URL description. Is there something I am missing or forgetting to do?… or is this not possible…
-
Ability to Reverse Populate a Form or "Slide" for Presentations
While using a form for data entry and collection, the same could be said for the reverse, being able to take data from a grid (either project plan, metrics sheet, etc.) and populate into a slide or sheet. For instance, I submit a form with information to be captured in a downstream grid, but can also generate a "slide" or…
-
Shortcut to Dashboard Header / Bookmarks
I have a pretty big dashboard of resources that are grouped under 9 headers. The top of my dashboard has a table of contents. Is there anyway to link a jump to those headers within the same dashboard? A link to a bookmark within the dashboard (not to another sheet)?
