-
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…
-
Put two fields from a report on a dashboard, and just those two fields, no column headers
I have a dashboard that shows a bunch of information about upcoming publications. Things like who is contributing, submittal deadlines, approval deadlines, etc. I have sheet with the publication date in it. I want this date to appear at the top of the dashboard. Literally something like: Publication Date: 05/11/2021 Is…
-
How can I display row numbers in a Report on my dashboard?
I have a sheet with a row of data. I have a report that pulls some of this data, and sorts it by suburb. I want to insert this report into my dashboard but include a row number to make it easier for those who view my dashboard to reference the data. Is there any way to do this? Thankyou
