-
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
-
Merged: "mouse over" interaction on a dashboard
This discussion has been merged.
-
Mouse-over / Alt-text to Dashboard Widgets
We'd love a way to add "mouse over" alt-text to dashboard widgets to accommodate individuals with color vision deficiency or provide additional context.
-
Help with COUNT forumula for column with duplicate names.
Afternoon, I am creating a reporting dashboard to report employee stats. Each of the metrics on my dashboard is fed from a dashboard calculation sheet. Each of the sections in my dashboard calculation sheet references another sheet based on different criteria. In each of these sheets, i have a column with employee names…
-
Populate Column With Unique Values From Another Sheet
Hi all! I have a sheet, where tasks are entered and assigned to employees. Every task belongs to a certain company, which is specified row by row (every row is another task), this describes the first sheet we'll call "Requests". I want to create another sheet to summarize the data of every task for every company, this…