-
Conditional Formatting - Report
I have set up a conditional formatting rule that is certain values are out of range, the cell is highlighted red. I'm having trouble setting up a report that only displays the rows that are highlighted red. I've tried to set up a helper column but can't find a formula that refers to if the cell is a specific color. Any…
-
Highlight Changes on Dashboard
Hello, I have created a Sheet with a form. I have taken the data from this Sheet into a Report, and then onto a Dashboard. I have turned on the "Highlight Changes" feature on both the Sheet and the Report. Anytime there is a new entry added to the Sheet through the form, it turns the data yellow. Unfortunately, this…
-
Error With Link To Report Through Dashboard
I have an issue with a shared viewer of a dashboard where they get a blank (no content) report when they click on the link in the dashboard. As the creator of the dashboard and the report i can see the content of the report just fine when i click through to it. However they just see it as blank! They are a shared viewer to…
-
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…
