-
Gantt View on Dashboard not starting at today's date
Hello! I have a report that summarizes deliverables from several sheets, with the information displayed in a Gantt view. On the Gantt Timescale Settings, the checkbox to open the view to today's date is checked. I created a dashboard and have the report on it with the Report Widget. When I load the dashboard, it properly…
-
How do I use the data from DataTable to build a Dashboard
I have a lot of data sitting in DataTable, and as per Smartsheet, you should be able to use this data to "Analyze and act on your data". But I can't find any resources online on how to actually do this? Since you cant create a Data sheet to do a simple "countifs" formula in your datatable. Some advice would be appreciated.
-
Colors on bar graph reverting to original color after trying to update the color.
I am trying to update the color of my bar graph from the default blue to red on my dashboard. I can change the color to red in edit mode, but as soon as I save, it reverts back to blue. None of my other charts on my dashboard are having that problem.
-
Enhancement Request: Dashboard open links in same tab
I would like to have the option to tell links to open in the same tab for my dashboards. I have some internal company wide sheets that I have shared by publishing in order to bypass setting up permissions to all of the pages. Where I have files they are linked instead of published to prevent access to anything private.…
-
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…