-
Add a Button To Collapse Or Expand a Grouped Report in a Dashboard
It would be nice if we could have it both ways on a dashboard. It can be frustrating that you can't collapse a grouped report if the person that set it up set it up expanded and vice versa. There could be a button somewhere on the report that collapses all or expands all.
-
Integration of interactive maps into Smartsheet.EU
Hello everyone, I hope you are all doing well! We are currently looking for a way to integrate maps into Smartsheet.EU (based on a database of distribution partners managed in Smartsheet). The purpose would be to filter locations (e.g. by postcode) to get a quick overview of possible partners for a given area and to…
-
Average if when date is current year
we want to update the formula to show the average # of problem solving days when the idea is a JDI and the opportunity was submitted in the current year. Current formula - missing component to reflect only submissions from current year. =AVERAGEIF({APD CI Tracker Range 5}, ="JDI", {APD CI Tracker Range 4}) {APD CI Tracker…
-
Charts Plotting 0
I recently contacted support to find out if there was an option within dashboard charts to keep the charts from plotting 0. I received the following response: Currently we don't have a feature in place that will prevent specific values from showing on the chart. At this time the only solutions that we can provide would be…
-
SharePoint Permissions and Smartsheet Dashboard permissions
It would be great if there could be a way that a SharePoint permissions groups automatically translates to a Dashboard's sharing permissions list or even a Smartsheet Group outside of using an API (which I haven't even attempted yet). Basically, we want to share a dashboard on a SharePoint. This SharePoint is locked down…
-
Dashboard Custom Colors
I created custom colors for a dashboard. I'm now creating a style sheet to document the dashboard's colors, fonts, etc. How do I find the RGB color mixture for the custom color I created?
-
Referencing a Title Widget on another Sheet
I have a dashboard that shows a variety of metrics and data. We were previously using the formula MAX([Modified]:[Modified] to show the last update to the project plan. However, what we found was that any small change to the plan gave the impression that the dashboard was completely up to date, when there were still some…
-
How to aggregate sheet summary data into another sheet
Hello, I am currently working on developing a workspace to track system testing. The way the workspace is currently set up is having a summary level sheet that has each script, and then a folder per script. Within each script specific folder, there is a script summary sheet and a test script sheet. There can be multiple…
-
Selecting columns for visualizing on dashboards
Hello Everyone, I'm stuck in figuring out a way to visualize the below. I know it could be a simple workaround. The current chart visualize the task name and the #. In the new chart, I would like to add a status. It's OK if I don't include the # but SS won't let me visualize them. Thanks,
-
How to change the name of a Summary Field on a Dashboard?
Maybe a dumb question but I can't figure out how to do it or if it can be done by searching on the Community. I have a source sheet of client data that's summarized into 3 Summary fields by the assigned specialists. I've then pulled those 3 fields separately into several Summary Reports that I used to build tiles on a…
