-
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…
-
Selected data cannot be charted. Please select a new range error
Hello- I have charts on a few dashboards all set up the same, and they all stopped working. I tried creating a copy of the reports used in the charts but that doesn't help. Below is what one of the charts used to look like. It's a stacked bar graph showing the balance for the last available month and the $ in Foundation…
-
How can I create a helper sheet that reads totals from multiple reports
I need to create a 'helper sheet' sort of like a metrics that will collect multiple counts from multiple reports so that I can chart it easier in my dashboard. I currently have 60 reports which each have 3 counts on them, meaning that each one would need to be charted individually. I would like to be able to create a…
-
Should be able to tilt widgets!
It would be great to be able to tilt widgets of any kind on Smartsheet dashboards.
-
dynamic dashboard update
Is it possible on a dashboard for a widget to be dynamically updated? In the image above the "In Progress" is "Rich Text" widget type. I want to be able to check a box (elsewhere…not on the dashboard, and based on the check box - it wouldn't say "In Progress" but it would display a report. I know i can't have a widget…
-
Removing Zero Values From Chart
I am trying to create a stacked column chart to show how many Statuses are being used per section (Section for Chart) in a project plan. However, I do not want any zero values to show. I have attempted to create a report for this chart, but I cannot get the chart to look the way that I want. What I want (minus the zero…
-
How to get project overall delay in days in Smartsheet
Hi While we use the Baselines on the task level to see the delays per task, is there a way to grab the overall project delay in days and also show it in the Dashboard? Thanks for any prompt Regards /Marat
