-
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…
-
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…
-
Incremental Baselines & Dynamic Baseline Linking
Problem: Current Limitations Destructive Updates: Currently, snapping a baseline is a global action for the entire sheet. There is no way to baseline newly added scope (new tasks) without overwriting and erasing the historical variance data of the existing tasks. Manual Data Entry: Users are forced to manually copy/paste…
-
Native Burnup Charts with Automated History Tracking
Problem: Current Limitations Complex Setup Required: Creating burnup charts currently requires advanced formula knowledge, "helper columns," or separate sheets to manually capture historical data snapshots. No Native History Tracking: Standard charts only visualize current cell values. There is no simple way to plot "what…
-
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…
-
Creating a report frm several sheets to assign tasks without adding an assigned column to each sheet
I have a collection of sheets (10-12) that all have projects in various stages that need a status review/update. This is a temporary process and I need to be able to assign each project to an employee, but these sheets don’t have an assignment column already built in them. Is there a way to set up an assignment system…
-
Changing single asset access on new membership model
Hi there - We recently transferred over to the new membership model. In the past, I could change a user's access on a single item in a workspace without changing the workspace permissions. For example, a user could be an Editor on a report but overall have Viewer access to the workspace. However, now I am finding that I…
-
Can you customize a Send as Attachment email subject line and body?
In attempting to add custom cell data in subject line of an SEND AS ATTACHMENT email, finding no luck. because unlike automations, with targeted rows, there is no true cell SEND AS ATTACHMENT can pull from. Am I missing something here? I have the helper columns in my sheet. I am in need of a monthly based export of REPORTS…
-
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…
-
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?
-
Is it possible to edit an email list in an automated monthly report?
I have a monthly report I send out that has a long list of recipients. I know I can edit the recurrence of it being sent, but does anyone know of an easy way to just add or take out people that get my email without having to recreate the whole thing?
-
How can I get calendar view to stop showing wildly inaccurate dates?
I have a grid view and two columns are assigned to start and end dates that define some intervals that get mapped to calendar view. The dates are all formatted correctly in the grid view. The problem is that the dates that show up on the calendar view are wildly inaccurate. Certain events show up as the wrong dates,…
-
countif from 8 different sheets with data criteria
Hello, I have a head scratcher here, I have 8 different sheets that I am trying to pull counts from and only from a certain day. Example: All sheets have a date of outreach, all sheets have a outcome. I want to pull the count of all outcomes marked "Mbr Reached" from 12/02/2025 from all 8 sheets. Question: Is there a…
-
Viewing Full Year in Calendar View
I would love to be able to view a full calendar year in calendar view. (We are a school district so I would want it to show July 1, 2025 to June 30, 2026). I create a Professional Learning Calendar every year and would to start using Smartsheet to do this instead of google sheets. I have transferred all of our PL events…
-
View a Full Calendar Year in Calendar View
I am new to using Calendar View. I have been searching around and messing with it today, hoping to move our district's PL calendar into Smartsheet (I currently build it in google sheets). Is there a way to view a full calendar year in calendar view? (We are a school district so I would want it to show July 1, 2025 to June…