-
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…
-
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 🙏
-
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…
-
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…
-
Should be able to tilt widgets!
It would be great to be able to tilt widgets of any kind on Smartsheet dashboards.
-
Multiple selection dropdown formatting in Metric Widget
Hi all! As of now, when using a Metric Widget in a dashboard that pulls from a multi select dropdown field, the values appear like this (see image), a blue-ish/cyan color as a background. It would be great to be able to customize the colors or even better, from a consistency perspective, to have the formatting pulled from…
-
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
-
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…
-
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…
