-
Organisational-Level Dashboard Placement in Multi-Tier Control Center Setup
Good afternoon, I am currently configuring Smartsheet for the organisation and have implemented a multi-tier Blueprint solution within Control Center. At a high level, the configuration includes two Blueprints: One Blueprint to provision Business Units (BUs), and A second Blueprint to provision Business Unit Projects.…
-
Number Color Conditional Formatting on Dashboards
I would like conditional formatting by color on "number" displays on dashboards.
-
Show all files that are pulling information from a file
We want the ability to see (on any file type) what other files are pulling information from the current file we are on to understand the dependency between sheets/dashboards/reports/etc.
-
Target range in graphs
I would like to be able to have a highlighted/shaded section on a graph indicating the target range desired for the data being displayed in the graph. For example, The graph is depicting the average number of patient's seen per therapist per shift… the target range is 6-8…. is it possible to have a shaded line parallel to…
-
Creating data to populate a dashboard
Hi all, I want to display a count of a particular item from 1 column (dropdown with multiple options) but need it to also cross reference another column (dropdown with multiple options). So example is if first column (Site) is "Preston" and second column (Contact) is "Warehouse" then give me a count of this combination.…
-
Receive Notification for Broken Dashboards Not Pulling Data
I have 2 thoughts… When a report/sheet name is changed, any dashboards that pull data from that report/sheet also keep that name change so that dashboards do not need to be updated with new file name when changing the corresponding report/sheet name. I would like to receive an email notification if a dashboard breaks so I…
-
Send Dashboard via email - manually and automated workflow
My idea is to create functionality to be able to send a dashboard snapshot via email from within Smartsheet, both manually and via an automated workflow. Ideally using an HTML format so any links in the dashboard are links in the email. Smartsheet Dashboards are fantastic and we use them heavily with our project teams and…
-
Reporting functionality on dashboards
I am trying to pull together a view of my portfolio that takes 7 projects and pulls the milestones. I want to be able to have the seven projects each be able to expand/collapse individually, ideally from the dashboard, however, I'm having difficulty figuring this out. Seems like it is an all or nothing setup. I have my…
-
Mobile app not showing "New" Chart. Error: Content Unavailable
I have a dashboard where I have setup a chart using the AI assist to capture the leaderboard for a scavenger hunt. The chart widget shows up fine in the desktop smartsheet app and browser. But in the mobile app the chart widget shows as "Content Unavailable". In doing some basic troubleshooting I made sure all users are…
-
Resource Workload Tracking
Is there a way to take the expanded view (I think it's called Workload schedule) of Resource workload tracking and embed it on a dashboard? I do not have the additional premium app of Resource Management but am looking for ideas for how to see my portfolio of projects with all resources assigned. I have turned on workload…