-
Struggling with creating charts on a Smartsheet dashboard
Hi - I am really struggling with the steps I need to take to convert a smartsheet with incoming form data into charts that reflect that data. I've gotten as far as creating sheet summary fields using COUNTIF formulas, then creating a report from those, then creating a simple bar chart from the report, but I can't figure…
-
When downloading a template set, the dashboard doesn't seem to download with it.
I have been trying to download the Project Tracking and Rollup as well as the Project Schedule Management templates, which are both supposed to include pre-made dashboards, but the dashboards do not seem to download or populate. When I move the template set to a workspace, the dashboards still do not show, and when I…
-
Connector Run Date: Pull into Dashboard?
Is there a way to pull in the the "Run Date" from Smartsheet Connector into a sheet/report/dashboard? I'd like to show the last time data was updated on a dashboard. The Auto-Number/ System: Modified (Date) is not reliable since it only shows the date/time of the run when data actually changes (Salesforce, in this case). I…
-
Is there a way to specify which rows I want in a metrics sheet for widgets?
Hi, I have a metrics page that links to a sheet with data on it. The metrics I am interested in are attached. On the dashboard, we are using a donut graph to show all four categories: Red, Green, Yellow, Gray. But now I want to create another one that only shows Yellow and Grey metrics (e.g., 5 hour training completed…
-
Embedding Metabase Charts in Dashboards and WorkApps
I'm trying to embed a Metabase report and/or charts into a dashboard using the Web Content Widget. I got an error message "We couldn't find any embeddable content from this link." Is there a way display their charts within my dashboard? Here's an example of a chart I'd like to embed. Thanks!
-
Dashboard: How to show the tendency of a chart?
Hello everyone! I hope my question is clear, English is a second language for me. I was wondering if any of you have tips as to the easiest way to indicate the tendency (like the stock market per exemple) on a chart on a dashboard? Is it possible at all or is there a widget or a way to do a calculation in a sheet that…
-
Pull a List into a Dashboard
I am creating a dashboard to summarize the work being done across multiple different projects. One metric I want to include is a list of the program officers. I have pulled a list of all the project lead names and identified the duplicate values (when a project lead is assigned to multiple different projects), but now I am…
-
Building Metrics based off report data
Is there any way (I do not think there is) to add metrics on a dashboard based on results in reports? OR To show the summary view in a report on dashboards. If not I can add a feature request.
-
COUNTIFS children based on project name
Hi, I am currently trying to extract data to add to dashboards for synthetics, and a requirement is to know how many sub-projects are in any given area. I am after a way to reference my sheet using a lookup function to return the number of children in each project with a certain column (Task name) The formula must look at…
-
Dashboard Widget show only Current User information
I am wondering if there is a way to set up a Metric or Chart in Dashboard that will show only the data that applies to the current user. Example: Metric Widget is set up to show all lines on a sheet that are open vs lines that are closed for a team of 7. Is there a way that the chart would just show Team member 1 the…
