-
Reporting functionality on dashboards
I am trying to pull together a view of my portfolio that takes 7 projects and pulls the milestones. I want to be able to have the seven projects each be able to expand/collapse individually, ideally from the dashboard, however, I'm having difficulty figuring this out. Seems like it is an all or nothing setup. I have my…
-
Mobile app not showing "New" Chart. Error: Content Unavailable
I have a dashboard where I have setup a chart using the AI assist to capture the leaderboard for a scavenger hunt. The chart widget shows up fine in the desktop smartsheet app and browser. But in the mobile app the chart widget shows as "Content Unavailable". In doing some basic troubleshooting I made sure all users are…
-
Resource Workload Tracking
Is there a way to take the expanded view (I think it's called Workload schedule) of Resource workload tracking and embed it on a dashboard? I do not have the additional premium app of Resource Management but am looking for ideas for how to see my portfolio of projects with all resources assigned. I have turned on workload…
-
Some team members can't assign others
We've recently started a new ticketing system on my team using Smartsheet. Overall it's going well, except for some reason, some of my team members are unable to assign tickets to others. The names don't show up when they start to type it in. I've checked, and they have the same access as everyone else. What could be…
-
How to create Icons into a Dashboard
Wondering if anyone knows how to include a link on a Dashboard to other Smartsheet grids/ reports with icons (not just a list)- here's an example :
-
Return blank when count total is zero
Can you give me a variation of this formula that delivers a blank if total counted is 0? I want to use it in forward months so I don't have to update the metrics sheet monthly, if possible. Thanks, Lisa I tried the IFERROR and IF(COUNTIFS( I could find but most deliver Incorrect Argument. =COUNTIFS({4Q2025 FPG thru Oct…
-
Rolling View - Timebound
Hi community! I'm trying to figure out a way where a report will filter and pull based on a time frame. I have a sheet where all of our cyclical events are listed with start/end dates. I want to provide a way where only current events (in progress today) and going through next 3 months are pulled. Suggestions on how to…
-
Adding a Table Widget to Smartsheet Dashboard similar to one in Power BI
So, here is the idea in Power BI we have a table widget which will show the required data we want. I know in Smartsheet we can make use of report for the same but why I am suggesting this is that instead of creating reports for every small piece of data to be shown on dashboard is kind of annoying so if we get a table…
-
Metrics Widget Formatting Issue
Hello, I have created several sheets and reports to be able to live track my progress in a teacher training program. I used a Metric widget to pull the remaining hours from my sheet into a dashboard which works beautifully in the desktop version, but when I look at the mobile version, the formatting is all messed up. I've…
-
Is there a way to send out automate sending out dashboards weekly?
We use dashboards regularly for status reports, is there a way to send weekly to specific individual either as .pdf or interactive? I found this discussion and know it is on the roadmap, anyone know if it has been developed?…