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…
Is there an easy way to get a diving line or border between widgets on a dashboard? The only thing we've found is to insert images of lines from Powerpoint - not the best.
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?
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…
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.
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
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…
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…
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…
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…