-
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…
-
Selecting chart widget colors for items with no data
This is driving me nuts and wasting time - is there a way to fix this I haven't come across yet? We standardize colors on all our chart widgets across dashboards, so data for multiple projects is easily read. For example, a chart widget totaling tasks by status will use blue for Complete, green for In Progress, orange for…
-
Create a Link to A Filtered Sheet
Does anyone know of a way to link to a filtered sheet? I want to create a number of links on a dashboard which when clicked on will show the same smart sheet but with a different filter applied. e.g. I could have a link that says "Red items" and another that says "Blue Items" the interaction on the link would be to open…
