-
Will creating a baseline report duplicate resource allocation?
Hello, in Smartsheet's "Project Management Fundamentals" course, specifically in the section on Reporting, there's a great example on how you can compare the original plan (baseline) to actual project dates. The solution illustrated here is to Save As New the original plan (BEFORE you modify any dates), and save it outside…
-
Connect MS Power Query to Smartsheet?
Can anyone explain how to connect Smartsheet reports to MS Power Query? I have tried creating API Tokens to connect some of my reporting, but I’ve been unsuccessful. I can “halfway” Access the Smartsheet via Power Query, but I’ve not been able to figure out how to access my content through Smartsheet and manage the data.…
-
Trying to create a report to use on a dashboard.
How do I create an 'At Risk' report, from a sheet, to include on my dashboard?
-
Report Issue
Still having issues with reports even though the down detector says they have been solved
-
Creating a PMO functionality
I have just been assigned the task of setting up the Project Management Office in my company. For now I need two things, firstly a project tracker for tracking and monitoring individual projects and then a master portfolio tracker where all the info that's updated in the individual trackers feed into. This master tracker…
-
Track Daily Variance Between Forecast to Actuals Across Multiple Cells and Sheets into Master View
Hello, I am desperate for some guidance on the best way to handle my situation. First, I have 2 sheets that I'm attempting to provide an executive view for: * First sheet is a forecast that indicates the number of people we should be training in any product line. The individual product lines are listed in the primary…
-
Workflow or Alarm
Hello all, I work in company established in Germany. So my english writing can confuse you. I am new here and want to ask a question regarding the workflow / alarm tool. The automated mails are linked to a formular or the receiver gets a link to the complete Project. Is it possible to link the alarm to a DashBoard? This is…
-
Conditional Formatting doesn`t apply to Report
Hi there, I was playing arround with the conditional formatting and stumbled across a problem. I have some rules, based off the "Modified" column. When those rules are used on a custom column, it works just fine. If the rule is used on a system column (Modified in my case) it doesnt seem to apply the colours in the report.…
-
Getting sheetnames to appear in certain order in a report
Hi there, Can anyone help with how to configure sheet name so it appears in a particular order when shown in a report? I have used numbers (1. Red, 2. Yellow....) and letters (A. Red, B. Yellow....) but both approaches do not work consistently. A-G seems to work but the following letters dont (see image) . The numbers seem…
-
Report and Calendar View
I created a report from a sheet. The report contains only a few columns. This report is intended to be mostly used for calendar view. The items we want viewable in the calendar are the same items contained in the report -- not the main sheet. In calendar view, if you click on a scheduled item, all the details from the main…