-
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…
-
Dashboard Assistance
Currently, I have a dashboard that reports on our Current and Completed jobs (two unique sheets). There's two fields I'm looking to add together and return the sum onto the dashboard to display our dynamic Currently Billed to Date number. Datapoint 1 - exists in the Sheet Summary for the Current Projects sheet. This…
-
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.
-
Dashboard Sheet name Hyperlink proposal
I have a dashboard with a summary report that shows all my records within my Smartsheet, within the report i have the sheet name column which acts as a hyperlink and takes the user to the associated sheet where the record is located. The problem is the link takes the user to the page but leave the user having to go and…
-
New and Ready to Build!
Hello all! My name is Sarai and I work for a municipal government in Texas. I'm new to Smartsheet and love learning new things. Currently, I am building an inspection compliance tracking sheet to oversee about 400 sites. Is it possible to build a dashboard that showcases all aspects of a single site based on an ID number…
-
Setting up Data & Configuring Gradient Bar Chart
Hello! I am trying to show a gradient bar chart in a dashboard. I have a sheet where I've pulled a report that has data for US States. Each state has a count for Yes, No and Blank. I want to represent a bar chart in a dashboard for this data that shows the Yes, No and Blank count information as a gradient. Below shows the…
-
Why is my sheet not showing up as a data source for a metric widget
Hello, I have two sheets in a workplace as show below. However, when I go to add a metrics widget to the dashboard only one sheet shows up as a potential data source. How do I get the other sheet to show up as a data source. As of now the metrics sheet is a column of descriptions, then a column of the calculations. The…
-
Dashboard can't be publish
When I want to publish my dashboard, it always show me an error message. The situation continue few days. How can I resolve it ? thanks.
-
COUNTIF for Items in Dropdown Menu and Name From Another Column
I am trying to make a metric sheet to populate information for a dashboard. The originating sheet is from a survey/form. I would like to count how many times each category is paired with the Highest Level Person in Attendance column. For example, How many times the SVP is attending the Internal Audit Program topic?
-
Dashboard Sharing
Hi All! Aside from sharing it using a public link, I was pretty sure that dashboards functioned like reports, where a user had to have access to the supporting/underlying sheet to access the information. Has that changed? And if I was wrong from the beginning…I guess my real question is: I do not want to make my dashboard…
