-
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…
-
Hyperlink Color on Dark Background
Hi, I'm new to SmartSheet so I may have missed something. When I add an hyperlink on a cell with dark background, is there a way to make the text white or any other color that would allow to read it? I thought the automatic mode would change the color, but it does not let me do so... any ideas? Do I have to stick with…
-
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.…
-
Ability to remove all source sheets from a report
I currently have a number of reports, which are having 100+ source sheets of active projects, once a project is complete I need to remove it from the report and respectively add new sheets. However, there's no easy way to remove those completed/cancelled projects from the report today, because I'll need to look at that…
-
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…
-
Exporting Workspace Shared To and Permission Settings
Hello!! Currently doing a review of who all has access to my workspace in Smartsheets. Is there a quick an easy export or something to see who all has access, their permission, and License type within a given workspace? Part of this exercise is determining who all is in my workspace and if they need Edit/Viewer access to…
-
Rolling View - Timebound
Hi community! I'm trying to figure out a way where a report will filter and pull based on a time frame. I have a sheet where all of our cyclical events are listed with start/end dates. I want to provide a way where only current events (in progress today) and going through next 3 months are pulled. Suggestions on how to…
-
Is it possible to get a report on use of Pins?
Can I run a report on users activity related to Pins? Or could a CSM request this report from professional services?
-
Metrics Widget Formatting Issue
Hello, I have created several sheets and reports to be able to live track my progress in a teacher training program. I used a Metric widget to pull the remaining hours from my sheet into a dashboard which works beautifully in the desktop version, but when I look at the mobile version, the formatting is all messed up. I've…
-
List workspaces API returns all workspaces in Plan (tenant)
As a plan administrator, I need the ability to list all workspaces in the plan so I can ensure tenant-wide compliance. Currently, I can only list the workspaces that are shared with my API account. This is a gap that puts our SOC 2 Type II certification at risk.