-
Dashboard count only if rows filled from a reference sheet
Hi. I am working on a dashboad to summarize some data from a reference sheet. I want to add a metrics widget that presents a sum of the number of rows on a reference sheet only if they are filled with a color completely. Details: I have a sheet with different project rows filled in green, indented under those are 'tasks'…
-
Is there a way around the row limitation on report widgets within a dashboard?
Hello, I have a dashboard which shows a summary of key information from a sheet that outlines purchasing history of our company. It pulls from a report that summarizes information from the main sheet as a widget on the dashboard, and allows viewers to scroll down through the history of purchases line-by-line should they…
-
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…
-
Simple widgets, like a date stamp, for dashboards
I would love to see Smartsheet develop a set of handy, easy-to-customize-the-format widget options for us to use on our dashboards. For instance, it would be great to be able to add a current date/time stamp. Other ideas include a countdown, scrolling ticker, timer, weather/temp, visitor count, etc.
-
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)…
