-
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
-
Dashboards - Linking to Attachments in a Sheet
I downloaded the template set for Policy Governance and Rollout. There is a SHEET called "Policy Governance Inventory," which has great information for tracking policies, their status, etc. The attachment column is great for easy access to each published policy. There is also a Dashboard included in the template set. The…
-
Using Reports on Dashboards - Current User
Hi there, I have a report that shows a timeline for each of our clients and it is filtered by Current User based on assigned tasks. I was working on building out some dashboards for our Account Managers and when I add the Report Widget to the dashboard it shows my tasks to the end user and not theirs. Is there a way to get…
-
how to create a report of a sheet ?
hi , i am beguinner with smartsheet and i would like to get my gantt schedule appearing in dashboard . therefore i read that we need to create a report , but i have no clue how to make my existing sheet ( schedule ) in report . can anyone explain me ? thank
