-
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…
-
SharePoint embed in WorkApps
Please enable Smartsheet’s approved domain and add SharePoint to embed content for WorkApps.
-
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…
