-
Dashboards - Charting
Hello, is there any way at all to chart alpha (not numeric) data in Smartsheet dashboards? e.g. I would like to make a pie chart with the percentage of projects that show "In Progress" or "Not Started". I seem to only be able to list the actual project/task titles (some are long) as labels, which is not very practical.
-
Can I display all or elements of my Smartsheet Dashboard in a Google Slides presentation?
I'm looking to display charts and metrics from my dashboard in google slides. Ideally, this would be a live connection. The only workaround I've found for now seems to be taking screenshots of my dashboard and pasting in google slides, but this will not work for my team's needs. I see there are google docs + Smartsheet…
-
Is there a way to get the Proof function active in the Dashboard?
Hello All, I have embedded the card view of my sheets into the dashboard directly but we are not able to access the Proof function. A message pops up saying m"Proofing is not Available". I have searched through all of the settings and I can't find a way to make the function available. Has anyone figured out a way to make…
-
is it possible to include a critical path in the report ?
is it possible to include a critical path in the report or in dashboard ? Unless there's some other way to get it out of the sheet into another sheet ?
-
Date Grouping for Gantt Dashboard
Hi Everyone, I'm trying to automate a sheet into a Gantt Dashboard, however I am having issues finding a work around to show the child and parent dates, as all the information is stored in one row, rather than 3 rows for example. Sample Column Names: Project Name, Task 1 Start Date, Task 1 End Date, Task 2 Start Date, Task…
-
Why can't I pick the data I need for a chart from a report
I have a chart that is pulling the information from a report that has additional columns which are used to make sure only the correct rows information is pulled from the base sheet. However, as I'm trying to do this the Chart will only select the whole report and not give me the option to select the chart data in the…
-
Missing Source error on all charts in Dashboard
I completed a new Dashboard this morning, and now every chart on that Dashboard is showing "Missing Source." Only one of my Dashboards seems to be impacted, and another Dashboard within the same Workspace is also not impacted. I've confirmed the following things: There has been no change in ownership of the Workspace, the…
-
Visualizing comments
Dear smartsheet-community, I have created a sheet where all of our projects are stored. The sheet is filled by a form where you can insert the details. After submitting the form an approval process starts where the teams can approve or decline as well as they can add a comment. My question is about these comments. Is there…
-
Help with month end formula
Hi, I'm building a dashboard to track referral responses. The missing part of my dashboard is I need create a formula that gives the total for each category by month and year. I can't figure out what function I need to add the the formulas I already have to break down the total by month and year. The formulas I've built so…
