-
Dashboard Pie Charts
I have a dashboard created to track how my employees are doing with completing their assigned trainings. I use Pie Charts/Donut Charts to track the number and percentage of completion and these link to the reports I use for the information. I want to be able to change the colors of the default blues to red and green so…
-
Changing series order in stacked bar chart?
I'm trying to show a summary of Projects, by both Branch and Status. I created the stacked bar chart below, but the Status series are in the wrong order and I can't find how to change them. The Status source column is a dropdown with the options in numerical order and the source sheet is sorted the same way, so I can't…
-
Showing a timeline (not programme) in a Dashboard
How do I show a timeline as a widget on the dashboard, not the programme breakdown with multiple rows. I am looking to represent a single row that represents the flow from one activity to the next so you can glance at it and see where we are and what's next. Thanks
-
How do I show a risk register in the dashboard
Hi, I need to show a risk register in the dashboard that only shows high risk activities, how can I do this? Every time I try, it says the data I am trying to show is incorrect and that I need to select different data. Thanks
-
Current User Chart from Metric Sheet Data
I am trying to create Current User Charts for a Dashboard. I know these charts are typically made by creating a report. However, I am dealing with more data then the report will support filtering. Currently, I have 4 sheets with a total of 54K rows (total across the 4 sheets). So I thought about creating a Metric Sheet and…
-
Map for Location Data
Hi, Is there any map feature that Smartsheet provides (or third party) to show on a map data of a location-column on a Smartsheet? Thank you!
-
Published sheets on dashboard can't be viewed by anyone shared to workspace?
Hello, I am trying to publish a sheet so anyone who views the dashboard can see and use the sheet. I am finding out that only people who have paid seats can view and interact with the published sheet. This is contradictory to my goal of having ANYONE who is shared to the workspace, even if they don't have a seat, view and…
-
Dashboard Links/reports continuity when a user is removed from account
At least two times it has happened where a user contributed to the build of a Dashboard for a report or link. The user is removed from the account due to change in role. All assets are transferred to another user, however dashboard links or reports do not and fail to display. On the second go around this required a…
-
How do I show both birthdays and anniversaries on the same calendar?
I want to add a calendar to my team's dashboard that shows both Anniversaries and Birthdays every year. I have the following columns: Team member Date (date of anniversary and birthday) Anniversary column to show this year's date (formula) Birthday column to show this year's date (formula) When I go into calendar mode, I…
-
Additional API endpoint for exporting Dashboards
Hi, I was wondering if there could be an API endpoint to export dashboards from smartsheet. Would be a reliable solution for the automation I am trying to create. It would be similar to going to a dashboard→clicking on file→ print.