-
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…
-
A Handful of Dashboard Questions (Empty Data, Chart Formatting, Enhanced Tooltips)
I'm starting to work with Dashboards a lot as people are wanting to see graphs and at a glance analysis of project progress. Yesterday during a meeting I was asked if I could include other information on my graphs and I could only respond with "I don't know, I'm still figuring this out." So I'll bring the questions to the…
-
Bubble Chart / Heat Map
It would be nice to have the following: 1) a poll that collects data based off of criteria for Impact for a given project 2) using a range of 0, 1, 2, 3, 5, 8 13, 21, 32 3) sum up the criteria for the Impact to use as a value in the bubble chart 4) a poll that collects data based off of criteria for Effort for a given…
-
Summary Sheet Formula and Milestone / Key Task Gantt
Hello community, I am new to using the smartsheet so hoping you can help me with the below. How can I update this fomula that I am planning to use in my Summary Sheet so that it only includes count of tasks that has a start date of in the future. I want to exclude those from my count. I consolidated 3 projects into one…
