-
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…
-
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…
-
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…
-
Sharing Qualitative Survey Results in Viewable Format
Hi All, I am looking for a way to display qualitative survey results in an easy-to-read format. Here's some background. Someone created a survey with over 10 open-ended questions and asked over 10 people to respond. This resulted in receiving over 100 unique responses. Some of the responses are as short as 5 words, but…
-
Grid Edit in Dynamic View
Please allow a grid-edit option for dynamic view so that a user can edit multiple entries at once. It is very time-consuming and cumbersome for a user to only edit records one at a time from the details pane.
-
Merged: Create report off of a sheet you are working live in
This discussion has been merged.
