-
How do I get a dashboard chart based on a report to display as a donut chart?
I'm trying to display a task progress chart showing "complete", "late", and "not complete" in my dashboard and for some reason the chart will display as a column chart but it won't display as a donut chart even though I'm referencing the same report. I'd prefer to display as a donut chart as I think it looks better and is…
-
Keep getting Selected data cannot be charted. Please select a new range.
Hello, I am trying to create a chart widget in my dashboard, but I keep getting "Selected data cannot be charted. Please select a new range." error. The report I am using is already summarized in numeric value. What is funny is I have report that I created a chart widget in another dashboard, and when I use that same…
-
Is there an issue with using reports on a dashboard to create a graph?
I've done this a million times - create a report, separated by campus with a total $$. Then add it to a dashboard and make a graph. NOTHING is working right now when I try to do this. I get an error that the data cannot be charted. What the what? Help anyone? Is this a issue since they apparently changed something in the…
-
Selected Data Cannot be charted
It does not matter which data I select, I am getting the error of Selected data cannot be charted. I even tried reusing a report that is producing a chart on a different dashboard, but I am unable to create new charts in a dashboard. Anyone have any ideas as to why?
-
Cannot create new Chart from a report
I can create a Chart in Dashboard from sheet well but from Report is not working now. I just try with simple Report (just contain 2 column Primary and Number) but cannot make the chart. Is there any changes recently right, because I haven't worked with Smartsheet dashboard for a long time and I remembered that I could do…
-
Native Secondary Axis & Mixed Charting
Problem: Current Limitations Scale Conflicts: Currently, users cannot easily plot two data series with vastly different scales (e.g., "Budget" in millions vs. "% Complete" in decimals) on the same chart; the smaller metric becomes invisible. Complex Workarounds: Users are forced to create "Helper Columns" (to manually…
-
Automated Dashboard Snapshots & History
Problem: Current Limitations Ephemeral Data: Dashboards are "always live." As soon as the underlying data changes, the previous state of the dashboard is lost forever; there is no native way to view "what the dashboard looked like last Friday." Manual Workarounds: Users must manually use snipping tools or "Print to PDF"…
-
Editable AI Dashboard Widgets & Dynamic Data Sources
Problem: Current Limitations Locked Data Sources: Once an AI-generated chart is created on a dashboard, the underlying data source selection is locked. You cannot simply "Edit" the widget to add a new sheet. Inability to Scale: If a project expands (e.g., a new team sheet is created), the existing AI visual cannot be…
-
The "Master Program View" (Dynamic Sheet Aggregation)
Problem: Current Limitations Reports are "Flat" Lists: Current Reports can aggregate rows from multiple sheets, but they function as static lists. They cannot perform project logic (dependencies, duration calculations) across those sheets. No Cross-Sheet Critical Path: There is no native way to identify a "Critical Path"…
-
Dashboard Report Issue - Report not showing data
Hi Everyone, Looking for some assistance on a dashboard report issue I am running into. I have a dashboard with 3 reports added as Web Content. All 3 reports use at 1 common sheet. All 3 reports are published as read only. Users are not shared the underlying sheets. All 3 reports have some form of filtering. 2 of the…
-
Report that includes multiple sheets
Hello - Is there a work around in a Report to list multiple sheets in an order that I choose? Sorting doesn't give me the order in which I want them to appear in the report or in a widget on a dashboard. I would like them in a specific order. Thank you.
-
Smartsheet Filters
I’m hoping you can help me out with a question regarding Smartsheet. We have created a exception report within Smartsheet and I am having an issue with a client row being recognized when a filter is placed on the particular smartsheet. For Example: on the Exception main page you have 50+ clients listed with all exceptions…
-
Revise Filter in Dashboard
I need to revise/expand a filter - the list of items in the filter NOT the filter name - in a dashboard I created. Is this done through the dashboard or through the main data sheet?
-
Sharing form links via a dashboard
I've created a Dashboard with links to all of the forms that employees may need to submit (mileage reimbursements, equipment check out, injury reporting, etc.). If I share the dashboard with an "All User" group will they be able to access and submit all of the forms on the dashboard?
-
Using Analyze Data to create Charts
I'm working on creating Dashboards and I don't want to have to create 100 Sheet Summary formulas as I'm trying to have the Analyze Data create a Chart to show me how many times a certain letter shows up (K,SP,P and U) and it creates this which is showing all of the rows that are currently on there not the ones that have…
-
Stacked Bar Chart to display Count AND percentage?
I am tracking orders in 3 statuses (Expected —aka my grand total; Rcvd; and Completed). I have a stacked bar showing the count of each, and this is the ideal visual i'd like, but i was hoping to also reflect the % of completed against Rcvd and Expected, and the % of Rcvd against expected. Is this possible?
-
Dashboard Data Label Display Issues
Hello, I have a dashboard with some pie charts and when I look at the pie charts, they look like this: But when my coworker views the same pie chart it looks like this: Is there a way to get their pie chart to show up like it does with mine? I'm in the Early Adopter Program and they are not but considering the modern…
-
Why can't I duplicate an AI request
I created a pie chart using Analyze Data from the AI menu. The AI did exactly what I wanted with the following prompt: Using a pie chart, represent the distribution of percent to do, percent in progress, and percent complete for the cohort 03-March 2026. When I used that exact prompt for a different cohort, 04-April 2026,…
-
Ability to set vertical axis scale on charts
I appreciate the feature in charts to scale to data values, however, I wish there were also a feature that allows you to set the scale for min/max. This would help viewers glean takeaways quicker, without having to reorient themselves to the scale for each individual chart.
-
Request for Dashboard Chart Widget to Support Multiple Groups in Report
Currently, chart widgets on dashboards that are sourced by a report with multiple groupings only display data for the first grouping. This request is to optimize the chart widget to support data from multiple groupings in a report. For example, in a chart widget, display how many hours are planned for each team member,…