-
Using Smartsheet to create Time Off Request Calendar, Dynamic View, Form, Report, in Dashboard
Hi all, Through some trial and error I created a Time Off Request system for my team (80 people) I started with grid rows: Employee Email (text), Supervisor Email (text), Division (drop down), Time Type (drop down: Vacation/Personal/Admin/Comp OR Sick/Bereavment/Jury Duty), Start Date (date), End Date (date), Partial Day…
-
Adding a total to a stacked column
Hi all, I am creating a dashboard with a stacked column metric of tasks by department, priority, and status. The stacks are coming from a metric sheet (see print screen). The end user wants a total of tasks by department either placed under the department name or at the top of the stacked column. Is this doable? And if so,…
-
Can you filter a Dashboard?
Hello, I currently have a sheet linked to a form where several employees input projects under their name and we have a calculation sheet for all the activities that feeds into dashboard that shows all the activities for the entire team. I would like to see if there is an easy way to filter this information into the…
-
Dashboard / Portal Background Colors
There have been a number of requests in the past for the option to have additional colors available for dashboards, especially to allow dark backgrounds to be used which are currently very popular. Can you advise if these requests have moved forward with the development team at all, some of them are over 5 years old and…
-
Calculating/Graphing Rolling Averages
Hello Everyone, My master data sheet has a column called "Date Opened" where the date is formatted as Day-Month-Year. I am creating a dashboard and want to create rolling averages. I would like it to count, the number of data points per day, month, and year. I also want to compute averages for these metrics. How would I go…
-
Smartsheet 201 - How to Build Reports and Dashboards - Free Smartsheet Webinar
I wanted to share an exciting opportunity to level up your Smartsheet skills! Tomorrow, our Customer Success team at DigitalRadius is hosting Smartsheet 201: How to Build Reports and Dashboards, a free webinar designed to help you create powerful reports and dashboards to enhance visibility and collaboration. We already…
-
Free Smartsheet Webinar Series by DigitalRadius
I wanted to share an exciting resource that I think a lot of you will find valuable! Our Customer Success team here at DigitalRadius is hosting a Free Smartsheet Webinar Series now through the end of the year, designed to help you unlock the full potential of the Smartsheet platform. It starts tomorrow! Here’s what’s…
-
A PowerBI novice's guide to embedding dynamic reports in Smartsheet dashboards
I've recently embarked on a foray into linking PowerBI with Smartsheet, with the goal of creating dashboards where data can be sliced and diced interactively, and which update with new data automatically. The purpose of this post is to share the steps I had to go through, along with a few learnings, so that other novices…
-
Any reasons why even though I am at 100% it shows as if it is like 10% visually?
I checked the reports where it pulls and everything is set up the same way as the other bars. any suggestions?
-
Dynamic View & Dashboard
I have created a Dynamic View for Directors to allow them the ability to approve or deny a request and add comments. I have included that Dynamic View to our Tracking Dashboard as a Web Content Widget but now ANYONE who has the ability to view that Dashboard can now approve/deny those requests. HELP! How do I still publish…
