-
Chart Formatting
I've created a chart that color codes requisitions by open or closed, its a pie chart to be specific. It works perfectly when neither of the values is zero. However when I get with a day with zero "open" for example, the formatting is lost. So that when I do get a day with "opens" Smartsheet shows the metric, but assigns…
-
Need help with creating report(s) with data from a Survey
Hello, I am still fairly new to Smartsheet and need some help turning around data from a survey I sent out. I have 600+ responses that I used the Request an Update function in Smartsheet to obtain, that I now need to summarize and I have no idea how to start the summary process. The survey is regarding Security Services at…
-
How to create a metadata sheet of associated metadata sheets?
I'm working on building a series of dashboards centered around individual projects, and I'd like to have a parent dashboard that rolls up all of the project data in one location. I've made the metadata sheets for the lower-level dashboards no problem, but I'm having trouble creating the overarching set. Here's the goals:…
-
Line Chart - Sheet Structure for multiple values
Hi All I've searched for a solution but again, being so used to just being able to select columns and rows in spreadsheet apps I'm really struggling with creating a line chart which has several columns of data I need to turn into a single visual for my dashboard I want to show the number of tasks raised by MONTH for each…
-
Current User Views on Reports/Dashboards
Hello! I am trying to create a dashboard for internal, unlicensed users to see tasks assigned to them, and I seem to be missing something because I can't get it to work. I have a report filtered to current user: I have the report on the dashboard set up to show the viewer's data: I have the user shared as admin to the…
-
Dashboard/Report link issue
Hi everyone, A person on my team has created a dashboard with a report widget that has a link at the bottom on it. The report itself has over 700 line items, which is over the 150 max per this article: https://help.smartsheet.com/articles/2482269-using-report-widgets We would like to remove the link. Alternatively, how do…
-
Dashboard chart - default disable lines
Hi, I currently have a chart in a dashboard which displays 15+ items as lines. It is great that I can enable/disable each item individually but is there a way to have them disabled by default when you open the dashboard instead of just showing them all then then going one-by-one to disable them (and showing just a couple…
-
Is it possible to get any statistics on if users have been looking at sheets and dashboards?
I don't want to track changes but get more of a viewership report to see if people are looking at the info we make available to them via dashboards.
-
Dashboard/Portal
I am getting an All data filtered out error when sharing sheets with other. What can I do to resolve this?
-
Report formatting on dashboards
Hi there, Is there a way to format reports on a dashboard so that when displaying in gantt view the columns to the left with the data remain static and the gantt chart is extended? When I display gantt reports on a dashboard the last column with the data tends to extend and then I have to drag the columns and resize each…
