-
Troubleshooting Sheet Summary "INVALID DATA TYPE"
Hoping that the community can explain this issue I cannot solve (nor can AI). Today we added a Y2026 Savings column to our sheet. Column formulas were all updated as well to look for values with "effective dates" in their corresponding years. Sheet Summary (for Dashboard) formulas broke returning "INVALID DATA TYPE". Tried…
-
Dashboard Ideas: Accordion Sections, Important Note to X Out, Hyperlinks Shortcut
A few Smartsheet Dashboard ideas: Title Widget Action - Click to expand or condense the section below Title Widget Action - Important notification banner that users can x out Shortcuts - Control or Command K shortcut to add URL hyperlinks Shortcuts - Copy formatting defaults to 10pt size text, can this be defaulted to…
-
Receiving an Error Code when Creating Chart
Hi everyone! I created a metrics table to count how many "Critical, Major, Lesser" observations I have per a CRO Management group for a specific timeframe (quarterly). The formula I used in the metrics sheet is as follows: =SUM(COLLECT({Audit Schedule Range 6}, {Audit Schedule Range 2}, "CRO Blood and Marrow Transplant",…
-
Set Dashboard as Default Homepage for All Users
Hi everyone, Is there a way to set a dashboard as the default homepage for all users upon login? Ideally, we’d like users to land directly on a particular dashboard instead of the usual default page. Is this possible through configuration, or is there a plugin or workaround that can help us achieve this? Thanks in advance!
-
Allow Summary from Report Group as a metric option on dashboard
The grouping and summary feature is great and in some circumstances may replace the need to create some sheet summary fields. However, in absence of being able to use as a metric on a dashboard, unfortunately this duplication may still be required.
-
Merged: A report is not available to be a data source for a Metric Widget
This discussion has been merged.
-
Help Article updates October 2025
Hello Community, We’ve published new videos on these topics: How to use columns in Insert, delete, or rename columns How to use timeline view in Introduction to timeline view Widget types in dashboards in Widgets for Smartsheet dashboards To view the entire catalog of help articles, visit the Help and Learning Center. Were…
-
Chart widget is broken on published dashboards
I'm running into an issue where chart widgets fail to display on published dashboards: The dashboard is published as "Read only - Full" with access control set to "Only available to users on the same Smartsheet plan" (to limit dashboard access to our org). As you can see, the metric widget displays summary data correctly,…
-
Metric Widget data source from a report
A report is not available to be a data source for a Metric Widget. I have a report that shows the one figure I want to be displayed on a dashboard. I cannot convert the report to a sheet and cannot seem to get the report number on my report to the Metric Widget… Can this functionality be added to use a report for a data…
-
Section Breaks for Dashboards & Consolidating Space
I'd love to see section breaks for dashboards so that if you are consolidating any empty space it is moving up only in that section, rather than the whole dashboard. It would help minimize a lot of manual time changing widgets!