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 informat…
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 th…
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 …
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
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 o…
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…
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 displ…
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, t…
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 c…