-
Dashboard Request: Track Sub-Task Completion Time from Project Start
We have projects with multiple sub-tasks, and we’d like to track how many days it takes to complete each sub-task from the project submission date. Ideally, we’re looking to create a dashboard that shows: Each project The average number of days it takes for sub-tasks to be completed (from project start/submission date)…
-
Can I create a dashboard from a multi-status sheet?
I'm using a smartsheet to track a 6 phase process where I'm passing information between teams in a linear timeline. Each of the phases has several statuses (WIP, Revisions, Approved, etc.). I'm trying to create a dashboard that allows me to see all how many projects are in each phase, and what status they have. Is that…
-
Metric Widget without Summary Sheet Report?
I'm trying to figure out a formula-free way to show summarized info. 😅 I have 3 Cities on my Sheet; each city has 'co-parent' rows, and under these co-parent rows are Tasks that have a Status. I'd like to have a Metric widget on my dashboard that shows the number of Tasks per Status, per City - for example, 'Tulsa' In…
-
Shortcut to OneDrive - NOT My Files
I am attempting to attach a OneDrive XLSX file to a Shortcut Widget on a dashboard. When I choose ADD SHORTCUT and select OneDrive from the list, the login to OneDrive occurs and I get a display of My Files. However this is not for me or from me. This a spreadsheet from an automated process(es) in a shared space on…
-
Was the option to change Dashboard background color only (not use a theme) removed?
I used to be able to go to the Dashboard settings and select a different background color. Today I don't see that option. Instead there are default themes or the option to create a new theme. I want to keep the colors I already have and only change the background color. If I try to create a new theme it replaces all of the…
-
Roadmap Infographic Widget for Dashboards
Roadmaps are a great way of communicating important milestones on a project. While Gantt charts and calendars are great, they frequently can be overwhelming, cluttered, and difficult to parse. This can be frustrating for a stakeholder. When it comes to designing a perfect dashboard, one rule of thumb is that a viewer…
-
Add Work Insights to Dashboards
I am trying to add summary charts to a dashboard, however it requires numerical values which are impossible to add for what I am trying to show in the chart. Excel can easily create a variety of charts to show me how many cells in a column show specific data, and the Work Insight in Smartsheet also shows me the data in the…
-
Merged: Work Insights -> Dashboard
This discussion has been merged.
-
Merged: Single Dynamic Filter
This discussion has been merged.