-
Charts - reporting on two 'Counts'
Hi, My company is logging Fire Risk Assessment actions, and we want to see a chart that shows: Actions by priority and then within that: Actions by 'complete'. So, for example, we want to see that there are 46 Minor actions, 19 of which are 'complete' (a checkbox), 144 Moderate actions, 130 of which are 'complete', etc. At…
-
Dashboard Sharing Best Practice
I've have a 3-tiered solution, with projects nested within programs, and programs within a single portfolio, all managed by control centre. At the portfolio level, there's a unified dashboard, providing the ability to navigate to any of the six program-level dashboards. Each program-level dashboard then presents multiple…
-
Any ideas on an easy way to capture data on a rolling monthly basis and show on a dashboard
We are capturing different types of statistics for multiple different subject areas every month and need to: a) easily get people to update the data b) easily show it on a Dashboard I've tried multiple different ways of sheet design but I keep coming up again blocks - ie either data can't be shown in a graph or the…
-
Can you hide the toolbar on a sheet embedded in a dashboard?
Hello! I have a dashboard that has a sheet embedded on it. I'm aiming to make it accessible to anyone with the link to it. There is one cell on the sheet that can be changed from a dropdown column and this will update all of the data on the sheet. I'd love to hide the toolbar and icons along the side so there is no…
-
Are Published Dashboards Mobile Responsive?
Hello - I published a "View Only" Dashboard for non-Smartsheet users, but the display on mobile is not screen responsive. Any time it is viewed in a browser, it is a horizontal view and will not adjust vertically. The user has to either flip their phone or scroll to the right/left. Is there a workaround or additional…
-
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'…
-
How can I update a dashboard real-time without end users seeing my edits on the fly?
I'm working on a corporate project in which "everyone" will have access to a dashboard with project updates. I plan to collect updates throughout the month, which requires me to open up filters, look for new projects, add new projects, and updates statuses. I'm worried about how to do this operationally without everyone…
-
The fonts in the report widget in all my dashboards have changed
The fonts in the report widgets in all my dashboard are now much larger and do not fit the widget size on my dashboard. This behavior is consistent across all my dashboards. The graphic widgets are not affected. Anyone seen this change? Is there a quick fix? I have a case open with Smartsheet - waiting for an answer will…
-
Metric Widget on Dashboard not pulling symbol anymore
Hello, I am hoping someone can help me to understand why I am getting an error now with my metric widgets in on a dashboard. Previously I was pulling a sheet summary into a metric widget that would show a "symbol" on the dashboard. Now it is showing an image error symbol and not pulling this through to the dashboard…
-
Unable to edit dashboard that I own
I created a dashboard that is used with our workapp. I just recently tried to update a widget but I keep getting an error message and it will not allow me to edit the dashboard. I am getting error message "Couldn't Save. Error: Validating Request - Dashboard 193838324 is not active. Can anyone help me understand what…
