-
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…
-
Projektfortschritt innerhalb der letzten 30 Tage
Auf einem Projektplan wird mir der Erfüllungsgrad des Vorhabens durch die Abhängigkeitseinstellungen (Start/Ende/Erfüllungsgrad) wiedergegeben. Auf einem Projektedashboard möchte ich gerne tagesaktuell, jeweils die zurückliegenden 30Tage betrachten und für diesen Zeitraum (Datum heute/-30 Tage) den %tualen Fortschritt…
-
Reports appearing blank in dashboards.
Is anybody else experiencing issues with reports appearing blank (or not appearing at all) in dashboards? Nothing to do with permissions as this is being experienced across the board, even by my team who owns and builds the dashboard and relevant assets. Sometimes they title of the report and the column names appear, but…
-
Dashboards Randomly Displaying Blank Reports
I have encountered peculiar behavior with my dashboards over the past month. My reports are randomly displaying as blank. When I refresh the page, it's a hit or miss on which reports display. I have to keep refreshing until the report I want to see finally displays its data. Recent changes: I've added a substantial number…
-
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?
-
Dashboard Reports Issue!
Hi All, I have unusual reporting issue which am unable to find solution in forum and am in need of some help. The issue: When I open dashboard one of the report just flick and then goes blank. Data / Filters testing: I've checked report, filters, all seems to be working fine and has correct data. Quick Fix: Refreshing…
-
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…
-
Recomendations on templates for project portfolio with dashboard
Hi, I am new to smartsheets and have been tasked to build a project portfolio (list of projects for each team with status, dates, notes) and then create a dashboard view. Can anyone recommend a template to build this quick and easy? We did have a consultant build a solution for us years ago but it did not work properly; so…