Would love to see this......We have several use cases I could see this being very helpful for reducing the noise for Senior Leaders...
At Engage I attended the class sharing the ability to add the ability to "filter" onto a dashboard via Smartsheet - it included multiple complex layers of formulas. We have utilized our Power BI reports, adding them to Smartsheet as a website, which enables their slicers. It partners amazingly with Smartsheet, together a dashboard can be a great tool! The only limitation I have experienced is PBI does NOT display hyperlinks, but Smartsheet reports can, which is why we partner them together.
Koleen Steiner
IT PM & Smartsheet Guru, BeiGene, Inc.
Right now to show large amounts of data for example it would be great for users to compare year to year by allowing the user to filter or splice the data with preset filters. In this example for them to view either 2023, 2024, or 2025 data instead of having three different charts taking up a large amount of space. This would also make dashboard more user friendly and convey additional information in a format that will be more impactful.
In my case, I want the display a filtered report using a date range. If I could filter on a date range, then only the necessary data will appear on the dashboard. This would allow the user to only interact with a Dashboard and not have to get into an underlying sheet. I googled it and there IS something out there but it doesn't appear it is part of smartsheet. Here is the link: https://www.google.com/search?sca_esv=591027850&rlz=1C1GCEB_enUS1084US1084&sxsrf=AM9HkKlXygoF-HE0GEYjEYZ7RRFRivHtGw:1702592633365&q=Can+a+Smartsheet+dashboard+be+interactive%3F&sa=X&ved=2ahUKEwivi-_o-4-DAxWSH0QIHTmeADMQzmd6BAgkEAY&biw=1920&bih=919&dpr=1#fpstate=ive&vld=cid:8ce1a899,vid:OY9PhETnShg,st:0
About 2.20 minutes in, you will see what I mean. It sure would be awesome!
This would be huge!
Dynamic filtering, Slice and Dicing data in Smartsheet Dashboards has been requested by so many of our clients and also in the community, we asked our tech wizards to build that solution. We call it Smarter Dashboards2.0 it was launched this week and is already getting a great reception from our complex users.
There is a 14 day Free trial and the cost starts at £125 per month. Let me know if you would like to try it?
more info here... https://smarterbusinessprocesses.com/smarter-dashboards-3/
Richardr@smarterbusinessprocesses.com
PS We did ask Smartsheet in Seattle in 2023 but it wasn't on the roadmap so we sorted it ourselves!
Richard Rymill
CEO Smarter Businessprocesses.com
Excel does a great job with this by providing the slicer function with table view connections.
Cheers,
Shawn Cullen, MBA, RMT, PMP, GPHR, PHR, SHRM-SCP, LSSGBC
Director Strategic Initiatives
ADP - NAS Operations PMO