RSVP for our FREE Work Smart Webinar Series on July 28th & July 29th!
Hey Smartsheet Community, Join us later this month to explore collaboration in three ways - content collaboration, centralized solution collaboration, and customized sheet views with Dynamic View. Wednesday July 28th: Personalize Sharing and Manage Business Processes with Dynamic View 10-10:30 a.m. PDT Thursday July 29th:…
Am I the only one who truly hates the new Dashboard UI? Since the new UI was introduced, it takes me at least 5 additional clicks and much more time to create a new dashboard or modify an existing one... I used to be able to "Save as New" an existing dashboard and modify it for the project, while keeping the layout. With…
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.