-
Displaying Pending and Submitted Update Requests through Reports or Dashboards
Hi, I am using smartsheet to manage the project work plan. Through the automation, I am sending update requests to task managers. I am worried that the update request emails be lost as some people regard them as spam emails. I thought if I can I show a list of pending and submitted update requests on either a report or…
-
Why doesn't the pie graph and bar chart always display the same data when the same data is selected?
I have 8 columns that have been summarized. I used a pie graph to display the 8 columns as a percent. I then tried to use a bar chart to display the 8 columns as a dollar amount. However, the bar chart will only display 7 of the columns. Any ideas what may be causing this?
-
Producing a chart on a dashboard to show resource capacity
I have created a report with information about task status and owner for a bunch of projects. I am trying to summarise this on the dashboard as a pie chart (ideally open tasks by owner); however, the chart shows the same owner multiple times in different colours because they have outstanding tasks for multiple projects. Is…
-
Dashboard Report Format Issue
Hi, Is there a way to change the colour of the label font showing in the dashboard for a report widget? The base report has them as black but when I view it on the report widget it shows as white and harder to see? See pics. Base Report pic: Dashboard view of the report: Any suggestions gratefully received. Thanks.
-
How to create a line chart in a dashboard?
Please read carefully! I want to create a line chart in my dashboard. I have 2 years worth of counts broken out by quarters. I want each year to be it's own line in a line chart. Any idea how I can create this? Currently, it's all 1 line. Thank you in advance. SB
-
Sheet Summary for Dashboard
So i have multiple sheets (15) which are all using the same template of marketing events. i created a dashboard which shows upcoming events in the next few days based off a report (pulling from the 15 sheets). I would like to add a metric on the dashboard which show (for example) how many webinars we have going across the…
-
Dashboard needs to update to include newly added fields names and counts...
I'm working on a dashboard that displays the Defect category or sub-category plus the count of defects within that category and sub-category. Currently, I have to manually go into the dashboard and update it when a new sub-category is added. What I like to have the dashboard do is add that new sub-category and count…
-
modified or last updated date (as a widget on a dashboard)
I feel like this is a pretty basic/noob question - so maybe point me to an old answer.. we have a dashboard and I just want to add a widget that has the last updated date. I see that you can have last updated in a column but this is for all the widgets on a dashboard. Is there an easy way to do that? Or even just a…
-
# of Tasks Assigned to Each Person from a Folder
Hi All, Working on trying to find a solution to the following. We have a dashboard we'd like to use to understand the workload across all of our standard projects. Specifically, we want to know the number of tasks assigned to each person by health status. The Folder "Standard Projects" includes multiple sheets, and will…
-
Milestones not showing in report on Dashboard
Hi, I created a Report based on a Sheet that shows 7 milestones in the gantt view. At first, on the Sheet the milestones weren't showing up, but they were showing up in the Report. I deleted all the dates & durations on the Sheet and re-added them (using 0 for milestone) and they showed up. I saved those changes and…