When building a chart widget from a Report, Smartsheet currently only supports a basic bar chart. If I try to create a stacked bar chart from a Report (to split the bar by a second field like Status, CoC, Portfolio, etc.), it does not work as expected.
This limits dashboard reporting because Reports are the cleanest way to roll up data across many sheets, but the visualization options are reduced compared to charts built from a single sheet.
It would be very helpful to support stacked bar charts directly from Reports, including:
- Stack by a second field (dropdown, symbol, contact, etc.)
- Preserve grouping and filters defined in the Report
- Support 100+ source sheets without requiring a consolidated “master sheet” workaround
