-
Question on graphing data on a dashboard while using a smartsheet form
Hello, I am trying to graph data for production as close to real time as possible. We run a test and then use a form to populate a smartsheet. I have a dashboard pulling from that smartsheet to graph the data. I want the graph to populate based on new data entries, however the graph will only populate based on the data I…
-
Dynamic Dashboards
Hello - I have a source data sheet with the below columns: leader category level access list Access list is used for row level security and ties directly to leader. From this sheet I have 3 aggregated reports: 1 for leader, 1 for category, and 1 for level. The reports are also filtered by access list has any of Current…
-
Collecting time range in form
I'm creating a form to collect the days and times that employees will be out of the office so that I can get the info onto a dashboard for the team to refer back to. Since Smartsheet doesn't have time fields for forms the best workaround I could find was using dropdown fields with half hour time segments and have one field…
-
Merged: Adding Slicers to Dashboards
This discussion has been merged.
-
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…