-
How to guide a stakeholder through a multi-step monthly review process?
We are managing a portfolio of projects that cut across multiple teams. Each team has a "spokesperson" that is responsible for completing a handful of reviews each month for portfolio governance, such as: Review report showing project milestones that they own Review report showing project milestones that are owned by other…
-
PowerBi Question - Hidden "Helper" Columns
Hello, I use helper columns in my compliance sheets that are used to trigger notifications when action is needed. Normally, as a best practice, those columns are hidden since they are not needed by the business. I need to create a centralized dashboard for my department and will be pulling in data from different data…
-
Dashboard - I didnt know this!
I have been using Smartsheet for years - and I am shocked that I am 1 day-old when I found out that this feature exists. Clicking on the legends will change the charts and graphs accordingly! Oh well - learning something new everyday (and this is what I love about Smartshweet!) Do you know any other cool features on…
-
Streamlining the workflow
Hi Smartsheet Team, I hope this message finds you well. I've been working on a project in Smartsheet and could use your expertise in streamlining the workflow. Here's a brief overview of the project: I've created a form to collect information from 60 individuals who will be reporting the number of hours they spend on…
-
Dashboard Formatting, Displaying Data, and Cell Linking
I am stumped by formatting in the Dashboard. The first pic is how I would like to display the development schedule on the dashboard. It is very clean in comparison to the only way I have found in SS (2nd pic). Any suggestions on how I can get the better display on Dashboard? I would love for the data to be in SS so the dev…
-
Number of Items Opened and Closed in a week.
I have a worksheet named "Rich Complaint" that holds the data. Another worksheet named "Calc Data" that holds the calculations for the Dashboard. I want to write a formula in "Calc Data" that looks at the columns in "Rich Complaint" named "Date Created" and column name "Date Closed" to determine how many items have been…
-
NEW! Dashboard Builder Enhancements
Hi Community! We are very excited to announce a set of dashboard editing enhancements that will allow you to create visually stunning and optimized dashboards even faster. Drag and drop an image onto a dashboard - When adding images to your dashboard, you can drag an image from your file system onto the canvas, providing…
-
Program Management: Metrics for RAID Logs
Hi all, I am working to mature one of our programs by creating a dashboard that encapsulates several types of metrics, but one set of metrics I'm struggling with is our RAID Logs. I am using a Smartsheet Blueprint to spin up our projects and each project has it's own RAID Log to track against. I'm hoping to hear of how…
-
Calendar App Dashboard Widget - ability to print
I have a dashboard that contains a Calendar App widget. I regularly print this dashboard to PDF. The Calendar App widget looks bad when printed, since the widget does not maintain the background coloring of the calendar. See example attached. It would be great to get this fixed before we get the automation to print…
-
Can we pull the capacity % information from RM to Smartsheet?
Hi, I am wondering if there is a way to pull the capacity % for the disciplines and roles that's already provided in the Capacity window (under the schedule tab in RM - snippet below) back to Smartsheet? The reason is that we are in the process of having 3 different RM workspaces for 3 different entities, however, the top…
