-
Metric Widget without Summary Sheet Report?
I'm trying to figure out a formula-free way to show summarized info. 😅 I have 3 Cities on my Sheet; each city has 'co-parent' rows, and under these co-parent rows are Tasks that have a Status. I'd like to have a Metric widget on my dashboard that shows the number of Tasks per Status, per City - for example, 'Tulsa' In…
-
Widget Report Format
Hello. I am building a dashboard with high level information including total requests submitted into the sheet. I was able to create a report and add it to the dashboard but I do not like the formatting. Is there anything I can do to customize and center the total number?
-
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…
