-
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…
-
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)?
-
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.
-
Reworked Empty Chart State to replace "Unable to display chart" in Dashboards
I would like to see a rework of the "Unable to display chart" prompt in the Charts widget. I am building a series of dashboards using Grouped and Summarized reports as the source data for charts, pulling basic counts across multiple sheets. These reports are counting open and overdue tasks, the goal being that they'll be…
-
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…
