-
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…
-
Pie Chart Linking to Multiple Links?
Hello, I am working on a Dashboard and have created a widget with a pie chart. I have been asked to link four separate links to each of the four categories within a pie chart (attached below). I see via "Widget Behavior" I can click out to one sheet/link. Is this even possible to do? I have an idea for creating four…
-
Display widgets on multiple dashboards
I have a series of related link-type widgets on a dashboard. Is there a way for those same widgets to appear on another dashboard? I know I could copy/paste or even re-build on additional dashboards, but I was hoping that if I update a widget on the original dashboard, the copied version would also update automatically.…
-
Chart series position and size
Hi SmartSheet since many years ago we asked as customers a simple solution to adjust the size of the series in the chart and most of all the position in the bar charts. It is really annoying see the number that correspond to one series in other position where it doesn't belong. Sorry but you release many enhancements but…
-
Project Dashboards
On a dashboard, when does the data refresh? Issue I am having is some data clears out on Tuesday night. Does anyone know what triggers the refresh on a dashboard or how to control it?
