-
Sheet Summary Data on Dashboard
Please allow setting a default font and size for sheet summary data in dashboard Metrics, or provide the ability to multi-select line items to apply formatting changes at once for visual consistency.
-
Adding Current Month Data To Dashboard and Metric Widgets
Hello Community, 1st Question: I am creating a dashboard for our compliance statistics. I have built out a dashboard calculation sheet based off other sheets as seen in the image below. I am looking to add only the current months lable and associated data to my dashboard to keep it clean. 2nd Question: I also have the…
-
Metric Widget - aligning metric
I am managing various review projects and need to report on the progress of steps. I am using a Metric Widget, but I cannot position the number returned to be centered or right-aligned. Here is what it looks like, and there is just a lot of white space to the right of the result. However, I am not able to resize the box to…
-
Metric Widget Question
I have a Smartsheet that tags complaints by theme using a dropdown where users can select more than one theme. I would like to create a Dashboard widget that shows number of complaints by theme. I've tried using COUNTIF on my metrics sheet, but it only pulls in the first item chosen, so it's not giving an accurate count…
-
Current user metric widget
I have an evaluation form that gets filled out and results can be viewed on a dashboard. I have two, one for the submitter to see only their entries and one for the location being evaluated and the viewers see only the evaluations that are pertinent to them. I have a sheet summary formula that counts the total visits and…
-
Metric Widget Font Size
It would be really great if we had a much wider range of font sizes available for metric widgets. Sometimes a metric really needs to make an impact, and the current size options are limited.
-
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…
-
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…
-
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…
-
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…
-
Can a metric widget be a hyperlink on a dashboard?
I have a dashboard where I am trying to include a metric widget that captures a hyperlink from a cell on a metadata sheet. The hyperlink is to a SharePoint document. The link does not carry over to the dashboard widget. Only the URL description. Is there something I am missing or forgetting to do?… or is this not possible…
-
Metric Widget not working with specific Grid Sheet
I have a grid sheet that contains contact information. I am trying to pull that information into a dashboard focused on specific staff. The plan was to use a metric widget to pull the contact information for that individual (i.e., Name, Phone Number, Email, etc.). When I add a metric widget and try to link to this grid, I…
-
Should be able to tilt widgets!
It would be great to be able to tilt widgets of any kind on Smartsheet dashboards.
-
Wanting to add a range of cells within a column using conditional formatting
Is it possible to use conditional formatting to sum up cells to use on metric sheet for dash? Or is it a sumifs formula? Or another sum formula. Or is it some report that I need? Thank you
-
Formula to Count Ages of Orders
I'm trying to create a formula that counts the open orders based on the date the order was created. The thing complicating the formula is that it's for a metrics dashboard, so I need it to count the orders that are between 1-3 months old, 3-6 months old, 6-9 months old, 9-12 months old and over a year. I'm at a complete…