-
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…
-
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…
-
Unable to change the colours on charts/widgets
Hello Everyone, I have some dashboards created and it seems that since this morning all the charts colour changed colour even though the correct colour is selected: I went to the Smartsheet status page and it seems all status are running normally. Anyone having the same issue? Many thanks Mariana
-
Merged: Allow the Report in Gannt View on Dashboard to display complete bar darker than not complet…
This discussion has been merged.
-
Dashboarding a specific cell
Hello all, I have a smartsheet set up to calculate an inventory as items are added and subtracted via a form. I want to dashboard the current total of the item. This is the top cell of a column. I can't get the top cell to display, as when I link the cells, it displays the old cell when a new one loads in. Any thoughts?
-
Sharing Issues with filters and edits
I was asked to help with some Smartsheet items (grid, dashboard, and report). I was given Editor (can share with others) for all three documents and I am on an Enterprise licensed account. With the Grid sheet: It also will not allow me to: add columns edit columns sort rows delete columns add column descriptions etc. It…
-
Creating a Multi-line Graph from Google Analytics to a Dashboard Chart.
Hello Everyone, I am attempting to chart some data from Google analytics to a dashboard. So far I have imported the data to DataTable then used connections to make a sheet out of it that as far as I understand should auto update. Then I created a Report of that same data so that I can create an auto updating dashboard…