-
I'm embarrassed to ask: How do you write an API
I have a report that beautifully aggregates data from 70+ sheets. I need one column from that report to populate a helper sheet that I have: Source Sheets > Report > Helper Sheet As the report grows with data, I want the helper sheet to grow with it without manual intervention. Ergo, the API question. Here's what I know…
-
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.
-
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…
-
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…
-
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?
-
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…
-
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…
-
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…
-
Published reports no longer include highlight changes, print, view icons
I have dozens of published reports that I've used for years. Below the title, there's always been the toolbar icons to print, highlight changes and toggle between calendar/Gantt/card view. In recent weeks, the toolbar has disappeared. I've tested creating reports from different sheets, and cannot make it appear. I need to…
-
How can I keep my grouping and summaries when exporting a report?
When I go to export my report as an excel or PDF, it does not carry any of the summaries and grouping. How can I fix this or work around this? Here is an example of my report vs what exported ( a portion)