-
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…
-
Dashboard issues
Hi SS community…. One of the biggest pain points for my team and myself is the space that is wasted on dashboards. When You display reports and Dynamic calendars etc. and the lines reported in the widget do not fill the space at that moment it leaves a ridiculous amount of empty space which for a dashboard does not bode…
-
Looking to have a stacked collum chart showing difference in values
Hello, I am looking to have a stacked column chart showing the change in two values over the course of past, present, and future dates. I'd like this graph to update with new dates automatically based on what is added in the tracker. The stacked column chart should display the months of a year in the x axis and thee…
