-
Linking data from multiple sheets to one master sheet - then to a dashboard
Context: I have a team of people with their own individual smartsheet trackers that each contain identical columns. I want to have the rows on those individual trackers automatically populate/update in one master tracker where I can see everyone's data at once. I have already tried reports - this doesn't work for me. The…
-
Widget size
Hello! Is there a setting that automatically expands the widgets as the lists in the widgets I added to the dashboard grow?
-
Help with sheet summary formula losing #REF with data shuttle
I have a dashboard created with a "Data Date" Metric at the top. Using the Created column to populate a "Data Date" column (text column +LEFT(Created@row, 18) I can add the date in the metric via a sheet summary field. When I refresh data pulled from an Excel sheet (exported by another program), I get a #REF error in the…
-
Guage Chart or Speedometer Charts
I couldn't find a gauge chart option in Chart widgets, any idea if it is available or any work around? It is strange - as this is very basic chart other apps/ Software provided for their Dash boards. Seems Customization is not an option in Smartsheet, I mean ever Excell can create a gauge chart.
-
Dashboard Widgets
Hello, We are in the process of revamping our dashboards, and our manager has provided a screenshot (first image) as an example of the desired widget layout located in the top left corner. However, we are unsure if it is possible to replicate this exact design. The best we have managed so far is depicted in the second…
-
Adjust Column Size in Metric Widget
Please give us the ability to change the column size within metric widgets. It is very difficult to get good spacing with a forced 50/50 column size. Couple examples here: If I could adjust the right-side column size, I could have a perfect metric widget. Please Please 🙏
-
How do I get a date value to show/change in a dashboard?
I have inherited and existing Smartsheet, which I am just learning. The dashboard has a metric widget with a week of, but it does not change we are stuck on one week. I have a column that is now labeled as "Week Of" the cells show the date as 07/28/24 and the column type has been changed to date. How do I go about setting…
-
Missing Data on Metric Widget During a Dashboard Global Update
Hello, I recently ran a global update on a dashboard in a child blueprint and found all existing projects now show a "missing data" in a metric widget. New provisioned projects do not have this issue. The metric is pulled from a sheet cell that is part of the project blueprint. The source sheet has not been renamed or…
-
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 Metric Widget Not Updating with Current Backend Sheet Value
Hi all, This is from a sheet that uses a formula to count down / display the number of days til end of Quarter. What is happening: Displays 37 when the backend sheet actually says 34. The dashboard does not update until I click to open the backend sheet then the connection seems to go through to update the…
