Welcome to the Smartsheet Forum Archives
The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.
Using reports in Sights Metric Widget
Is there way we can use Reports within a the Metric Widget in Sights? I have a set up where I am trying to display "Counselor of the Day" in this widget, but my only option is to use the sheet as a source. When I do this, the link to the source cell is static and It only points to the cell that was initially selected. I am trying to make this a dynamic/live widget, where it would show the current dates assigned counselor.
I thought this would be a relatively easy task via report as the source, as I would filter the report to current date, but i realized I can not use reports as source in the Metric widget...Any ideas how I can accomplish this in Sights via the metric widget?