-
How to create a chart from a report!
Hello! I am trying to create charts using multiple sheets so I created a report. Although I am not able to figure out how to make it a chart. When I go to chart, it is all grayed out and won't let me select anything. I read that you needed to have a summary section and a group section, so I included both, but I still can't…
-
Count if formula to include multiple years
Hello, I am attempting to count all the submissions for 2023 and 2024 - my current formula only allows the dashboard to reflect the current year submissions based on my helper column for the year of submission. Does anyone know how to update the formula to count all submissions from 2023 AND 2024? Current equation:…
-
Map On Smartsheet Dashboard - Overlay With Locations and Data - How To Instructions
How to Add an Interactive Map to Your Smartsheet Dashboard The Challenge One of my Smartsheet consulting clients recently asked how we might be able to accomplish this. They have projects at multiple locations across the US and wanted to see them on an overall dashboard. The requirements: Display all locations on a single…
-
Dynamic Dashboard Template Customization
I'm new to Smartsheets and learning by doing. Currently I'm working with the Dynamic Dashboard template to create my own Dashboard that filters for a given faculty last name, then pulls key details about them from a larger Faculty Information Sheet. I've worked out how to set a form that has a dropdown menu of all of their…
-
How to get my calendar to properly display on the dashboard
I cant figure out why, but when people view my calendar in the dashboard, this message displays. They used to be able to view it, and now it shows this. How can I fix it?
-
How to count total number of times a value appears in cells with multiple values.
I have been trying to find a formula to use that will let me count the total number of times a day appears in this column. I would like to ultimately put this info into a graph on the dashboard. Is there a way to do this? I have tried using the COUNTIF with CONTAIN and I haven't been able to figure it out while on a…
-
How can I click into a report in a dashboard and have it bring me to the sheet?
Is there a way to be able to click into a row in a report on a dashboard and it brings you back to that specific sheet? Not to the report, but the sheet that the row was created from? So far I can only find out how to go back to the report. Is there even a way to do that?
-
9-box talent assessment
I have googled and cannot find any company that has automated the 9-box talent assessment outside of excel. I feel like this is a huge miss as all large corporations do talent reviews and succession planning. What would be really cool is if you had all your HR data in Smartsheet and you could have a visual of each team on…
-
Need to duplicate dashboard and attached reports/sheets
I have a current 2023 dashboard and need to duplicate it for a 2024 dashboard while keeping the same sheets
-
Resizing the Image Widget
Is there capability to adjust the white space around the image, in the Image widget on a dashboard? When I insert a logo, there is a good amount of white space bordering the image, and therefore takes up much more room that it needs to on the dashboard.
