-
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
-
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…
-
Am I unable to create stacked bar charts from reports?
Hi, I'm currently trying to build a personal dashboard so that each person in our team (~75 users) is able to see their own individual metrics. One of the things I'm trying to build is a view where we can see their time spent on individual tasks as a percentage for each month over the last 12. Naturally with this being a…
-
How to count total number of requests submitted?
Hi, I am trying to find a formula to count the total number of requests submitted in my grid. I want the formula to count the number of request ID's displayed. I want to use this number so I can display a metric on the dashboard. I also want to use a formula to count the number of "In Progress" requests and use this to…
-
Counting Text Color
Hello, I am working on creating metrics in our Smartsheet milestones. Currently, if a milestone was completed on-time, the date completed is turned green. If the milestone was not completed on-time, the date completed is turned red. What I would like to do is create a formula for metrics that reads the text color for how…
-
Dashboard Metrics
I'm looking to create a Metric Widget that pulls the newest data from one cell in one column that is submitted through a form. For example, we are creating a form where people can submit a bid for a car. I want to take the most current bid submitted and have that feed into a widget. I have the form set up so the data…
-
Dashboard metric widgets display is not same for data pulled from same sheet
I'm trying to figure out why the font size of the numbers are not the same for all the metrics widgets. They all pull from the same portfolio metrics sheet (shown below). Is there a way to adjust font size so On Hold and # Completed values (2, 3) are the same size as the other metrics. Appreciate your help!