It appears that I can only make a graph of the whole report instead of only one column. Is this possible to do? If not, do I need to make a sheet of the data of every single column of the portfolio? For example: I need a graph of the column "Responsible area" of the portfolio, to get the data of how many projects has each…
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…
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:…
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…
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…
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?
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…
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?
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…
I have a current 2023 dashboard and need to duplicate it for a 2024 dashboard while keeping the same sheets
