-
Chart widget with AI - Static or Dynamic?
Curious if anyone has had luck with creating charts using AI and adding them to their dashboard and the chart updates when refreshed with data changes in their sheets?
-
Merged: Give the option for Shortcut Widgets to open link in same tab or new tab
This discussion has been merged.
-
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…