-
Reports vs. Sheet (reporting / dashboards)
I am struggling because I have a very large SHEET that has many many data points that I have created a REPORT to create a BUDGET summary and projects for Quarterly Portfolio review(s); however, NOW I have to create a REPORT from this REPORT so I can create WIDGETS / Charts on a Dashboard; however, I know it isn't a thing…
-
Why does my Metrics constantly stop calculating correctly?
I've been making a "Metrics" sheet for some time now, and in the beginning everything was calculating fine. But it seems to be when I add more "data tables" if you will, or more metrics, some tables stop calculating correctly. Here is what my sheet looks like for a better understanding So, the first few-ish sections will…
-
How do I make a Basic Cashflow Line Graph?
I have to think I am just missing something obvious, because I am having the most difficult time using the Dashboard to create a Line Graph that shows my cash flow over time. I tried using only two columns (again, this is a very basic chart) that has the dollar amount figure, and the date that the amount was recorded. My…
-
Progression chart
Hi everyone, I have a questionnaire solution that only reports the latest attempt to answer it. It records how we as an organisation are doing against ICO Guidelines. My manager has asked me to create a dashboard that shows progress. So a line chart that will show how the organisation is progressing. My problem is the…
-
Best way to have a client facing dashboard act as a communication hub?
Hello All! We have a client facing dashboard (draft) setup, but we have not rolled it out yet. I have included a screen shot. We are in process of finalizing a more broad set of information. Pretty basic setup as of now. I would like this to be a client eco system, where they get all of their information and do all of…
-
Dashboard date not updating from source sheet
Hi i have created a Dashboard that had a widget with the date. This changed automatically with the formula =today() from another source sheet. Since last week in dashboard this date stopped to update automatically and still is showing Jan 13, 2023, but the original source is showing today date. Any idea why this is…
-
Table of Content in Dashboard
It would be great if one could auto-generate a Table of Content (new Widget) in a Dashboard by indicating which widgets should be part of the Table of Content and then Links would be generated either at the top or the bottom of the page (selectable) that would link to the different sections of the same Dashboard.
-
Dashboard - error pulling data
I have created a Dashboard. I am trying to pull the report data in as I have always done. I keep getting an error message. I re-created the reports and initially it will work. As soon as I hit "save" I start getting error messages. Help?
-
Stitching to together multiple Dashboards into single presentation
Hi Fairly new to Smartsheet, and I'm trying to replace my powerpoint-based Project Status Reporting with Smartsheet. I have multiple Smartsheet dashboards defined for a project e.g Project Overview Stream Report RAID Register It would nice if these could flow in a single presentation. I've tried adding a [Next] button…
-
Using most recently added row to populate dashboard
Hi - I'm building a dashboard for project reporting, and need the most recently updated row from my data sheet to be used to populate the Metric Widgets. The data needs to come from a sheet rather than a report as I want to display the data split out into areas, not all in one place. I've done a lot of reading, and so far…
