-
Parent row in report
Hi i have a sheet with ~2000 rows and ~1200 tasks. each task is assigned to worker. the worker need to see only the culomn that i choose in report and update only one checkbox column. the issue is that i want to display to worker the parent rows... and in report i not assigned the worker in parent row.... ony the specific…
-
Update Requests - Displaying (via Reports or Dashboard)
Does anyone know if there's a way to Display Pending Update Requests? We're using a lot of automation to send out Update Requests to team members, and I'm concerned that they're going to get lost in emails. It would be great if I could build a report, dashboard, etc. that showed all the Pending Update Requests. Mike
-
Displaying multiple milestones on a single line in Gantt view
Hi there, Is there a way to display multiple milestones, denoted by diamond symbol, on a single line when it Gantt view? It would be useful when tracking multiple projects if there was a way to have a visual overview of key stages in one place without each milestone for each project being displayed on separate lines and…
-
Report Grouping Issue
I have report that summarized about 38 sheets using sheet summary fields. For some reasons, one of the fields isn't coming through so the report is not grouping properly. It's only happening for a few sheets but it's the third time it's happened this week. To fix it I have to go in to each sheet summary, take a letter off,…
-
Report will not average negative values correctly for baseline variance.
Hello, I have a project sheet that calculates Variance from the schedule baseline. I am trying to create a report from this sheet that shows the average Variance for each supplier (from the Assigned to column). As you can see in the image, some of the variance values are negative, and some are positive. When I try to use…
-
Can I use automation from a report instead of a sheet?
I have about 30 different smart sheet files that each have a couple tasks assign to my team. I created a report that pulls the tasks from each sheet and lists them out. I would like to create an automation from the report file that sends out the tasks as the due dates approach. There is no automation feature in the top…
-
Count Rows in Reports
Currently there is no way to capture and report the number of rows in a report (or across multiple reports). It is common in dashboard reporting to create a metric (or card visual) to count the number of specific items in a table by simply allowing an application to count the number of unique or distinct rows. For example,…
-
Does Smartsheet's offer something like MSFT CoPilot
Is there any AI assistance available in Smartsheet's?
-
Reporting - Using Two Sheets, Getting Duplicate Rows
Hi All - I've created a report which uses two sheets. The goal of the report is to leverage columns from both sheets as they both have data I want to report on. Sheet 1 actually copies to Sheet 2, so all the formatting and column names are the same, but there are additional columns in Sheet 2 for other reasons. When I…
-
Hiding Or Removing Duplicates In a Report
Hi all! I have a report on a sheet that has many duplicate values, and for the sake of nice presentation I would like them hidden. To further explain my situation, I have a sheet I am referencing that has tasks, days to complete, the week of completion of these tasks, and finally the avg days to complete a task per week.…