Dashboard Widget Not Displaying Data on Save as New – Possible Issue with Cell-Linked Sheets

Options
Sachin Kumbar
edited 06/13/25 in Smartsheet Basics

We're encountering an issue where certain dashboard widgets fail to load data from their connected reports.

✅ What Works:

  • Widgets connected to reports that pull from simple sheets (with no or minimal cell linking) work as expected.
  • The dashboard also retains the data source correctly during copy or instance creation.

❌ What Doesn't:

  • Widgets linked to reports that are connected to sheets with extensive cell linking or even basic formulas fail to display.
  • Error message shown:
    “Unable to display chart – source sheet or report can't be accessed or has been deleted.”

🧠 Question:

  • Has anyone else faced similar behavior?
  • Is there a known limitation with using cell-linked sheets in report-based dashboard widgets?
  • Any workarounds or best practices to handle this scenario?

We’d appreciate any insights or guidance from the community.

Thanks in advance!

Answers