-
Webinar recording: Dashboards introduction and best practices
Missed the webinar? Review the recording in the Learning Center. Join us for a two-part webinar series focused on Smartsheet dashboards. Introduction to Dashboards Learn how to build a visual Smartsheet dashboard to provide a robust, real-time view into data from your sheets and reports. Dashboard design best practices…
-
Problem viewing a published dashboard embedded when publish settings are set to anyone with a link
Are there limitations to viewing a dashboard when it's published with the settings of anyone can view with a link? I have dashboards that some people can access easily but others get the errors below. I have included our settings that show they are enabled as published to anyone with a link. Note: One is embedded into a…
-
How do I create a report from various forms?
Ok, so I have about 17 forms created for various employees in different departments. Each employee is required to fill out this form x amount of times a month. I want to make a report to auto populate that shows how many times employee filled out the form, and I want the report to show the employees percentage of completed…
-
Adding forms to a Dashboard
Hi there, Is there a way to create hyperlinks to go to a form that is already created? I am trying to create a central hub for all of my team requests to sit under, so we can send out one link and have all the different requests sitting there instead of sending a different form link. Right now, I only figure out how to add…
-
Intranet on Smartsheet
Hi All, We're trying to move our old intranet onto a smartsheet dashboard. One feature of the old intranet was a direct feed of daily comics to start your day with a smile. I'm trying to find some feeds that will serve the same purpose. Another feature of a world clock, showing the current times for all our locations. Has…
-
Milestone coloring and Multiple Label Options
Can you add these features this year?
-
Reduce horizontal axis labels in a chart
I am trying to chart a lot of data point over multiple years but there are way too many labels on the horizontal axis. Is there a way to reduce the number of labels to allow the chart the be understandable?
-
Multiple sorts/countifs of different columns
Hello - new user here! I have a new sheet with ~200 rows with ~25 columns. I have created a form to feed data into the sheet and that is working great. A few of those columns include creator name, department, category, and a few other 'metadata-type' fields. I'm struggling to create summary reports of those 'metadata-type…
-
Dashboard to show % of projects completed on time vs not on time?
Our projects have Due Dates and Completed Dates which I imagine most do. How can I can create a dashboard (pie chart) indicating % of projects that are completed on time and % that don't complete on time? Do I have to create a new "tracking sheet" with just this info on it first as a middle step? Seems like it should be…
-
Automatically display the most recent text-based comments into a dashboard
Does anyone have any guidance of how to take a response a form that could be several sentences and feed it into a dashboard preferably chronologically? I'm setting up a survey where volunteer rate their experience at an event (which fits into a chart nicely) and then can leave additional comments that I would like…