-
Is there a way to have the legend options go in order based off of the percentage? Most to least?
I want a better way to show the preferred items based off of the percentages. Is there a formula or a better way of showing this data more efficiently?
-
How to use summarized data from report in chart widget
I'm using a program report to summarize data across several hundred projects. The report is working well and shows the sum of the data across all of the projects. I want to show only the summarized row from the report in a smoothed line chart widget. The users have access to the report, so I don't need to show the detail…
-
Selected data cannot be charted - shouldn't be happening
I have a report that I want to use as a data source for a chart on a dashboard. The report has summaries and the required grouping so that the top-level row of data can be used for the chart. Even though there clearly is numerical data for a chart to be created (see below), I am getting the error - "Selected data cannot be…
-
Widget storage for dashboards
It would be helpful to have a storage option /space for dashboard widgets. Some months I have charts for various units, other months I need a text box with title to show there is nothing to report this time. Widget storage would make dashboard updates much faster.
-
Dashboard Background Colouring Theme Limitations
Hey there, Is there any way you can work on the theming widget for dashboards? It is extremely limiting and not very user friendly. Major pain is when trying to set coloured backgrounds for widgets. It either all or some. Especially when you add in images or rich text some formatting of background colours don't work. Would…
-
Charts not matching numbers
I have multiple semi-circle pie charts on a smartsheet dashboard but the chart is not matching the number. See below for example. The amounts show that funding is about 50% to goal…but the pie chart is not showing that percentage in graphic or in %. How do I fix this?
-
Am I able to Change the Order of Items in the Legend on a Chart?
We would like to keep things consistent across the board for our PM's and business owners when it comes to the RAID Log. I have labeled them "1., 2., 3., 4." and it works in certain instances, but it's all over the place once we pull that info into charts on a dashboard. It now looks extra confusing. I am very new (3ish…
-
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.
-
Adding a dashboard link to a different dashboard
I'm trying to add a dashboard link as a shortcut widget on a different dashboard. When I click Add Shortcut, then Smartsheet Item, I can see all of the sheets and reports, but not any other dashboards. I know I can add it as a website, but I want the dashboard symbol to be visible. It has worked previously.
-
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…