-
Set a Min-Max for Axis on Charts
I really like Dashboards and how it can visually tell where a project is at. What I do not like are the fluid charts. I would like to be able to set a Min-Max axis instead of having the axis change as items progress. Case in point with this script update - the min is 86% and the max is 102%. I want it to show from 0-100%.
-
Merged: Persistent custom colors
This discussion has been merged.
-
Creating multiple graphs in a dashboard from one report or source sheet
I feel like I'm missing something - using only core applications, is there a way to create multiple charts in a dashboard for ongoing data (meaning every time a row is added I want the graph to be fluid to update accordingly from one report?) My understanding is if I'm selecting from the source sheet, its stagnant data and…
-
Is there a way to turn off the auto-open for the workspace panel?
This has just started happening in our company and is quite annoying for our folks. Is there a way to stop it from opening every time our employees open a dashboard, sheet or report? It is just extra clicks all day long they don't need to be making!
-
Create links within Dashboard to jump from one section to another section.
This question was asked in 2020. Wondering if there has been anything done on it since then?
-
Duplicate Rich Text Widgets to another dashboard
Hi, We have a project that has a SS dashboard with all the updates ("Master Dashboard"). We have another dashboard that would duplicate some of the RT widgets from the Master Dashboard. How can we do this automatically? Trying to avoid duplicated efforts for the same exact content. The content has some rich formatting, so…
-
Metric Widget not working with specific Grid Sheet
I have a grid sheet that contains contact information. I am trying to pull that information into a dashboard focused on specific staff. The plan was to use a metric widget to pull the contact information for that individual (i.e., Name, Phone Number, Email, etc.). When I add a metric widget and try to link to this grid, I…
-
Line Charts in Dashboard not displaying data - requires save to display?
I've built numerous dashboards and have never encountered this error previously. i have a formula: =AVG(COLLECT({Material Requests (Draft) Range 10}, {Material Requests Range 1}, "1", {Material Requests Range 2}, "2024", {Material Requests (Draft) Range 3}, "Central")) This results a figure (0.39) and when I go to chart…
-
Is there a way to utilize one sheet for multiple projects, but still roll up into a dashboard?
I work in an IT department as part of a fairly large school district. We typically don't super fancy PM tools other than a project name, all the tasks associated with that project, who is doing those tasks, and when they need to be completed. So each division in our department has setup their own sheet which as multiple…
-
Building a Dashboard off of my Status column
So I am want to build a dashboard that will track/show how many complete, not started, and in progress tasks I have. I have four separate sheets that I will be doing this with. Each having about 8-12 tasks that will be tracked. The problem is which I will share below is under each "Task" I have a Indent where committees…