- COUNTIFS- CONTAINS/FIND/HAS
Set-up: I have a data prep sheet that references a master sheet and some other sheets so it is easier to set up a dashboard. I have a list of departments in one column (Column5), and the count formula in the next column. The formula works when there is one department listed in the reference but not if there are multiple…
- Display all series in the legend for Pie & Donut Charts even when the value is 0
目前是饼和炸面圈的传说harts will not display a series in the legend if the value is 0. All other chart types do, but Pie & Donut do not for some reason. This is really frustrating when creating dashboards, because if/when the value updates to a non-zero amount the series colors get all wonky & you have to…
- How can I get the legend for a pie chart to display ALL series even when their current value is 0?
I've been having this issue while building dashboards for a while. I want to use a pie chart, the data contains 4 series. The values will update via their formulas over time, but right now the value for 3 of the 4 series is 0. For all of the other types of graphs, all series are displayed in the legend regardless of their…
- Showing Sheet Summary Data in Another Sheet?
I am building SheetB to compare my budget by categories (data entered manually for now) against my actual expenses (entered in SheetA - totals for each category are part of my Sheet Summary data). Is there a way to reference those Sheet Summary totals in SheetB? Ideally, I will then be able to use SheetB to create charts…
- Option to remove zeros from Scatter Charts
When using a scatter chart any value of 0 is plotted on the axis. It would be great to have an option to toggle off displaying these values. It crowds the scatter plot with junk information. Here is a before and after example where I use a formula on the metrics sheet to change any zero values to null values. With 0 Values…
- Printing from dashboard does not fit to page
Hi I have created a dashboard but when I go to generate the pdf, it only fills 70% (ish) of the width of the page, adjusting the % in the print dialogue settings makes not difference unless you are shrinking it, and changing the page from A4 portrait to A3 portrait gives the same result. Any ideas on a fix? Thanks Lee
- Removing widgets from dashboard view if access is not already granted
When creating a dashboard some widgets will be hidden for certain users. The outline of that specific widget (report) is then still visible with the message stating it is not accessible. The widget should not be there at all. This results in the dashboard looking incomplete and I do not want questions from the blocked…
- Cannot embed Data Studio Report in Smartsheet Dashboard
Does anyone know if Looker Data Studio was removed from Smartsheet's allowable domain list for embedding? I was able to embed reports just a few months ago into a Smartsheet dashboard, and now when using either the embed code or embed URL, Smartsheet does not recognize the code. Error returned: "We couldn't find any…
- Dashboard width full screen
This is a request for dynamic dashboard view. At the moment the dashboard has a fixed width view, not making the best use of full screen area. We have instances where more than 50% of the screen is empty on the left/right.
- Edit reports on a dashboard
Request We need an option for the report widget that would allow users to edit report rows while viewing them in the dashboard. The problem I'm trying to solve: I have a report widget on a dashboard that shows users their assigned tasks. I'm using the widget on a Dashboard to give the users one place where they can see and…
