-
Project Team Widget
I want to make a dashboard widget for my project that shows a report containing all individuals that were assigned a task in said project. I know that the "assigned to" column can be pulled in a report, however it shows multiple instances of each person because each person does multiple tasks in each project. Is there…
-
Dashboard View
Good Afternoon, I'm interested to see if the capability exists to change the orientation of dashboards. This may be basic, but it seems that portrait orientation is about all you get unless you limit the amount of information and customize the orientation in the print function. Does anyone know of any other way? Thanks a…
-
Report filter not working properly
Hi, I'm not sure if there is an inherent filter mechanism as part of Smart Sheet reports but I am trying to use the report filter function to only show rows for specific information. Column 1 - list of products (e.g. apple, orange, grapes .. etc) Column 2 - list of groups that buys the product (e.g. group 1, group 2, group…
-
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…
