-
Sharing a Sheet with a Filtered View
I have created a dashboard with multiple KPIs that are sourced from a sheet that contains all of the raw data. I want to have the user be able to click the KPI widget and view the data that falls under that specific criteria. I have multiple filters set up on the sheet with the raw data, and have linked each KPI widget…
-
Stacked Bar Chart Labels Unable to Show Negative Values
I reached out to Smartsheet support regarding a labeling issue I encountered. When displaying data in a stacked bar chart (example on right), data labels do not appear for negative values. I can only get the negative values to appear on a regular bar chart (example on left). Per the support team, any combination of columns…
-
Dashboard and Widget Action
When creating a dashboard, I have been creating charts and linking to reports using the widget action “open another site” and using the report link. The reason is my team prefers to have the report open in a new tab. Currently, I’m going into each report and adding view access for each user. I have several reports in each…
-
Easily Navigate to Dashboard Widget Data Source
I often have to navigate to the data source of a dashboard widget to make updates, however there is not a direct link to the data source, and sometimes the naming of the source does not make it easy or clear to find. It would be very helpful if there was a button next to data source to "Open Data Source in a New Tab" or…
-
Support display form link to shortcut widget
I want to display some shortcut link in dashboard. I use shortcut widget and when select data source, there are 3 options (website, Attachment and Smartsheet Item). When I select smartsheet Item, it only refer to Sheet and Report type, there is no Form item. I don't want use Website link because it is not flexible when I…
-
Conditional Charts in the Dashboard
I would like to display a KPI if a condition is true ([boolean field] = true). Scenario: I have a helper sheet checking data entries for errors and a second helper sheet counting the errors. I would like to display a KPI on the dashboard showing the count of errors only if errors exist. The KPI then points to a report that…
-
Dashboard menu dropdown for navigation to other dashboards
I've seen lots of discussions on using dropdowns on a dashboard for interactive reports, etc. I have a slightly different question. I am starting to collect several dashboards, typically grouped by some category: Manager views (financial, workload, etc) Staff views (assigned tasks, vacation requests, other resources)…
-
Creating a Status Dashboard - Color-coded Widget help / ideas?
Hello all, I have an idea for a dashboard I am creating to have a simple status legend with drop-downs (green - on track, yellow - at risk type of thing). I created a sheet and report with the legend, so no issues there, but I am trying to figure out a way to reflect this on my dashboard. Ideally, I would want there to be…
-
Widget Behavior Open a Form
Hello Smartsheet, improving the widget's functionality to directly select the Smartsheet Form Name instead of the Form URL would greatly enhance efficiency, especially in Control Center project creation. Currently, Control Center doesn't capture the exact link due to it being an external link, leading to frequent updates…
