-
How have folks summarized statistics from multiple sheets to feed a chart widget?
Our marketing folks use a new sheet for every campaign. During the span of a few months, there could be several dozen such sheets active. They are all built from a template and reside in the same folder . Within each sheet there are several summary fields that can indicate number of tasks, number of unstarted tasks, number…
-
Metrics from Report for Sight
I currently have a sheet for each account manger that lists there account and a few key metrics. I then created a report that brings in all of the 10 sheets into one place so I can see our entire portfolio. We move/add accounts often so the report allows me to see total book in a much easier format than linking. I have a…
-
Are Dashboards working as intended?
Hello, I am trying to build a simple chart in a Dashboard based on data from a Report. When I am in Editing Mode I can select the Report, build the Chart, and change some things until it looks good. Then when I click Save (to get out of Editing Mode), the Chart that I once could see now says "Unable to display chart. We're…
-
How to hide the item # column & reduce header size in a published report
In the below example, I have embedded a report widget (top) and a web content widget (bottom) in a dashboard. In a published web content widget, is there a way to hide the item/row # column, and a way to reduce the header size to appear similar to the report widget? Thanks.
-
Lookup Functionality in Dashboard
Hi Experts, I am having a set of data in excel built based on multiple weeks and would like to bring the week-based values in a Dashboard. Likely I need to have a Dropdown value as Week 1, Week 2, Week 3, and Week 4. Selecting this Week should make the data display.
-
Going Crazy!! Need help! Dashboard Metric
What am I doing wrong? I'm setting up a dashboard (picture 1). The Sheet Summary (picture 2) is capturing the correct Median value using the formula =Median([Data Approval Cycle Time]:[Data Approval Cycle Time]. Super simple formula even I cannot mess up. And I mathematically verified the median in Excel. When I set it up…
-
Dashboards and Minor Analyses
Hi there - I would like a summary sheet to describe the work captured in one of my smartsheets. I think it ought to be a dashboard, but I am having trouble finding the right solution -- I THINK this is because I probably need to do an intermediate step. I would like to have a summary sheet that pulls info from a Smartsheet…
-
Report / Dashboard - Grouping option not working
I added a grouping in a report to organize the display in a dashboard. I want to group the report by type of project and for each type of project sort by go live date. When I am in the report, the grouping works. However when I pull the report in a dashboard, the grouping is not taken into account, only the sort by go live…
-
Dashboard Charts Not Updating Automatically
Hi, Issue: Dashboard charts not updating automatically. Source Sheet, Summary Sheet and Dashboard Setup: Source Sheet: List of tasks, has (amongst other columns) [Frequency], [Status], [Due Date] and [Task Due Today] (Formula to determine if the [Due Date] is today's date). Summary Sheet: Uses the Source Sheet as it's…
-
Metric Widget Alignment
I'm trying to align a title and a symbol in a metric widget. I can do this in a report, but the widget is visually more appealing. In the classic view, the symbols align tight to the title, which is good because the widget size is kept small. But I'd like to have them all aligned in a row. In the new look view, the symbol…
