-
Novice user, Build Reports
Hi. I have a sheet in which we enter transactions and the date they occur. I would like to generate a report that sums the number of transactions over a certain period. This report could then be emailed or accessed via URL, etc. Is this doable? Thanks!
-
Reports: Sorting groups of rows by the end dates of their respective master rows
Hello! I am hopeful that I can find the solution to this issue. This is a bit of a long one, so get comfortable! I am using SS to organize the workflow of active jobs at our precision manufacturing facility. Each job requires almost 100 independent job steps from start to finish. Each individual job task is on a separate…
-
Avg formula % complete based on a specific end date
Hello, I would like to know if it is possible to create a formula that calculate the average % complete for all tasks that are ending at a specific date (important milestone) in my schedule. The schedule I have have a lot of tasks going all the way to 2020 but I want to track only those that must be completed by Nov 2018.…
-
Manually Adding to Reports
I'm looking for a way to pull information from other sheets, while also being allowed to manually add data. The reason I'm doing this is to allow for staff to go to one place where we can share individuals goals, tasks and progress. Is there a way to do this? I have tried formulas, but I do not believe it updates when that…
-
Report Blank
Hi, I'm trying to create a report based on a sheet I'm an admin on, but it's coming up blank. I build the report based on that sheet, so all the column match. If I select a different sheet it works & shows all the information. I tried deleting it & starting over, still seeing nothing. Not sure what's going on. Help? Thanks!
-
Reports Malfunction
Hi, Are reports malfunctioning with anyone else today? I thought I was doing something wrong until I read the past community posts suggesting prior issues with reports. /-RI
-
Report Builder - What section
Hi, I'm trying to number actions on my list as 1.1, 1.2 etc, all relating to a section 1 in my smartsheet. I also have a handful of actions that I need to number as 1.6a and 1.6b etc. When creating the Report Builder however, the 'What' section doesn't seem to handle the letter, only the number, therefore any rows that…
-
Sights needs some improvements
Sights has been out for about six months now, but there are still no graphing widgets. When is SmartSheet planning on coming out with this functionality? Graphs are some of the main things people will look at when viewing a dashboard. Currently all we can do is list a whole bunch of raw numbers with little to no visuals. I…
-
Smartsheet's Error in % Complete Rollup
Hi, I recently realized that Smartsheet has a major flaw in rolling up % Completion. In Smartsheet %complete for a Parent is calculated as a weighted average of %completion of the immediate children times the duration of the Parent. For example in the following Project, the overall % complete shows 50% where the correct %…
-
Using the Project Management Dashboard Template
Hi all, I'm a newbie to Smartsheet and am evaluating its use within our organization and so far I like what I see. As a PM one of my tasks to do project status reporting and so I had a look at the Project Management Dashboard Template, this is a good basis for what I want to do. However, if I update the task dates in the…