-
'Report' where users cannot change parameters/filters/fields
I understand there are Dynamic Views, but it is a little restrictive and limited. is there a way I can share a report with someone but not allow them to change the parameters on the top section (sheets, columns, filters)? without locking down the entire report with "Read-only"
-
Report Printing - Missing Info
I have a report pulling information from 3 sheets. I have results Grouped by the 3 sheets. Why won't the Sheet Name print for the Grouped section?
-
Filter Groups
How to have a filter in a report that shows line items where: - if doc type is one of 8 values AND ASCP is not blank AND if start is in the past AND (% complete is zero OR %complete is blank) OR - if doc type is one of 8 values AND ASCP is not blank AND if finish is in the past AND % complete is less than 1 i've taken a…
-
Ability to Change Your "End Date" in a Smartsheet Report
It would be VERY helpful if we could allow users to change their End Date in a report for a Task. We have 2 Date columns in our project plans. Start Date and End Date. When a user is working off of a Task Report, it would be much simpler if they could change their End Date as to when they completed their task directly…
-
Report Row Ordering:
Hi experts, I'm creating a report that aggregates rows from four Gantt chart sheets, with the goal of displaying each Gantt stacked chronologically, but am seeing some of the rows displayed in the wrong order (see figure). Is there a way to control how rows from different sheets are displayed? Thanks for any assistance!…
-
Project Tracking and Roll up
I'm working on this and is there anyway for the reports i create to not make changes to the existing working smartsheet? I'm afraid I'm going to mess something up on the working smartsheet. As in, if I move columns will it also move on my working smartsheet? How would I change or identify the primary column in a report?…
-
Merging two sheets in a report prior to API pull?
We run an intake process within a main sheet where people submit ideas (say there are 5 statuses). When it reaches a particular status (say status 2), the main sheet pushes that row to another sheet where we track a sub process. When that subprocess is complete, we manually go back to the main sheet and switch the status…
-
Dashboard Request: Track Sub-Task Completion Time from Project Start
We have projects with multiple sub-tasks, and we’d like to track how many days it takes to complete each sub-task from the project submission date. Ideally, we’re looking to create a dashboard that shows: Each project The average number of days it takes for sub-tasks to be completed (from project start/submission date)…
-
Merged: Built-In Sheet Health Metrics: Help Us Monitor Limits Before They Break Us
This discussion has been merged.
-
Metric Widget without Summary Sheet Report?
I'm trying to figure out a formula-free way to show summarized info. 😅 I have 3 Cities on my Sheet; each city has 'co-parent' rows, and under these co-parent rows are Tasks that have a Status. I'd like to have a Metric widget on my dashboard that shows the number of Tasks per Status, per City - for example, 'Tulsa' In…