- Overdue Tasks Metric
I have an individual task report set up for everyone in the company which aggregate tasks from our project sheets. Then, we have an overdue task report that displays all overdue tasks for everyone, grouped by the assigned-to column. We have a summary field on the overdue report counting everyone's current tally of overdue…
- Data Meshing from a report to another sheet wipes out the data
I created a reported and I then exported that report into Excel and then uploaded that Excel into Smartsheets as it's own sheet. I want to be able to data mesh from the report to the target sheet, but even though it's identical information when I data mesh it wipes out all of the information from my Assigned To column.…
- Is there a way to weight the average in a sheet summary report?
I have a report that pulls from the sheet summaries of multiple sheets. One of the fields divides two other fields to show the % of items completed. However, when grouping & adding summaries to each column, the % completed summary averages the values below it rather than showing the actual % of items completed. In the…
- Report - not showing all the columns
I want to create a simple report from a schedule. I am the owner of the schedule and I have a good variety of columns: However, when I create my report, it shows me that only the following columns are available: What am I doing wrong? Thanks.
- Calculate Average of Task Progress, per Person
Hello, I am trying to create a dashboard showing the average task completion status' of a number of team members. I feel this needs to be completed in Sheet Summary, but can't figure the right formula... Essentially trying to get; AVG of Column [Status], IF Assigned to [Joe] Any clues? thanks PS. the dark rows are parent…
- 嵌入式报告显示崩溃吗d by default on dashboard
Hello, I have a report that makes use of the new grouping functionality. I have it embedded on a dashboard (since use of the filters and grouping is not quite ready for prime time with the report app). Even if I collapse all of the groupings in the report before saving, it still renders as completely expanded when embedded…
- Report Help Needed - Mileage recording for multiple people/entries mobile report issue
Greetings- The park district where I work has a healthy adventures program where people can enter mileage earned in different categories and groups (via SS form). So the same person (and I don't know who they are in advance bc it can be anyone) can enter multiple entries throughout the year. John Doe entered 15 miles of…
- Overview of Assigned tasks and status of different sheets
Hi guys, I'm quite new, so my apologies if this is quite a silly question. We would like to have a sheet that summarizes the open tasks of everyone in the organization. I first tried to structure one Client Sheet, so that I can later add all of our other clients in the same format. I added two screenshots, one of the Sheet…
- Reports and Sheets limited to printing 100 images only
One of the team has asked about printing to PDF a Sheet that contains more than 100 images embedded in the Sheet (not attachments). When attempting to print, only the first 100 lines of data is displayed. Has anyone worked out how to overcome this? (I don't want to have to separate PDF's.)
- Ability to export Utilization underlying data
Currently, any Utilization reports generated from Resource Management are only able to export high level data, and not any of the underlying data. The underlying data (such as utilization on a daily basis) is needed sometimes. Smartsheet support confirmed that the current Utilization report does not have an option to…
