-
A PowerBI novice's guide to embedding dynamic reports in Smartsheet dashboards
I've recently embarked on a foray into linking PowerBI with Smartsheet, with the goal of creating dashboards where data can be sliced and diced interactively, and which update with new data automatically. The purpose of this post is to share the steps I had to go through, along with a few learnings, so that other novices…
-
Pre-Built Chart Color Schemes
Our team would find it very useful to create pre-built themes for charts without affecting the rest of the dashboard. As an example, we use a color scheme of red/blue/green/gray for status updates but would love the ability to save a palette of different shades of blue to display other metrics without confusing end users…
-
Links in dashboard freezing
Over the last week or 2, I'm finding that dashboard links 'freeze', ie. stop working after some time, ie. maybe 20 minutes or so after dashboard opened. This is happening with dashboards via the desktop app, and with Chrome and Edge browsers. Once it's 'frozen', as I move the cursor around the page, the links are 'dead',…
-
When will timeline view be available on dashboards? Struggling with dashboard
Hello, I am struggling with representing our project timeline on our team dashboard in a summarized, visual way. If I include a report with a Gantt chart on the dashboard, the Gantt chart task labels appear very small, and overall it is not visually impactful. I noticed Smartsheet recently came out with a Timeline view,…
-
Question on graphing data on a dashboard while using a smartsheet form
Hello, I am trying to graph data for production as close to real time as possible. We run a test and then use a form to populate a smartsheet. I have a dashboard pulling from that smartsheet to graph the data. I want the graph to populate based on new data entries, however the graph will only populate based on the data I…
-
Dynamic Dashboards
Hello - I have a source data sheet with the below columns: leader category level access list Access list is used for row level security and ties directly to leader. From this sheet I have 3 aggregated reports: 1 for leader, 1 for category, and 1 for level. The reports are also filtered by access list has any of Current…
-
Collecting time range in form
I'm creating a form to collect the days and times that employees will be out of the office so that I can get the info onto a dashboard for the team to refer back to. Since Smartsheet doesn't have time fields for forms the best workaround I could find was using dropdown fields with half hour time segments and have one field…
-
Dynamic Filter on Dashboards
I really miss allowing the user to actively filter information from their dashboard view. I wish I could have a filter button that could be positioned on the dashboard. Then the user could choose to see the data of a period or a project, for example.
-
Merged: Adding Slicers to Dashboards
This discussion has been merged.
-
Freeze columns in a report on a dashboard
If a column is frozen on a report and that report is used in a dashboard, it would be helpful for that freeze to apply when viewing the report on a dashboard.
