-
Dynamic View link to dashboard?
I have set up a dashboard for employees to access important links, reports, etc. Each employee has a unique link set up to show their certifications. We have these links captured on a sheet, and each one is assigned to an employee, which can be viewed as Current User. I set up both a Dynamic View and a Report filtered by…
-
How do I get the counts to both be black...it's hard to see some of the white colored ones.
-
Show the latest comment, if posted within the last week on dashboard
Hi SU Community, I received some feedback from our CEO on our last meeting. He would like to have a simple visual all of the latest comments for all of our projects - if they were created within the last week. He is not picky about the way this information is given (Dashboard, report, email update, etc). It should show:…
-
Which formula do I need "Has" or "Countifs"
I'm having trouble knowing what type of formula to use in my dashboard, and how to get the results that I need. To preface - I am very new to Smartsheet, and the use of formulas so pretty much "learning as I go". What I have here is a result of combined YouTube videos and LinkedIn learning Smartsheet 101 videos. Let me…
-
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…
