-
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…
-
Exporting Report's with Grouping
I have researched that currently we cannot export to pdf or excel in the grouping format that it shows in the Report. I have noticed that this has been discussed and mentioned for a few years but little information or anything to suggest it is actually being worked on. When will this be updated/timeline? As I unfortunately…
-
"Allow multiple values per cell" filterable on Reports
Being able to filter a report with the "allow multiple values per cell" feature clicked on. The number of workarounds we have to do to try and use the "contains filter" vs. just being able to click on the drop down, is frustrating. It would be much easier to be able to click on one of the drop-down options.
-
Mysterious strikethrough being added during automation process?
Sheet 1: team manually enters weekly updates to dates and metrics Sheet 1 Automation: weekly Friday morning trigger to copy all rows (~5-15 rows) from Sheet 1 to Sheet 2 Sheet 2: ledger of all updates made week to week Report: Pulls in Sheet 2 from 12 projects, displays 8 columns, filtered down to just the prior 2 week's…
-
Merged: Group items from a dropdown list
This discussion has been merged.
-
To much Dynamic data
I have 12 grids (One for each month) that have dynamic (Column 1)offices, (Column 2) Appt Types. (Column 3) Amounts for those appt types, I need to combine them into 1 report but the report starts over each month stacking. So i though i would combine all 12 months into 1 grid but then i end up with duplicates(Offices and…