-
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.…
-
I want to report the values of mixed data types in a single column
I have many many sheets where column names are the same but data types are different (ex: some "Assigned to" columns are text/numbers and some are contact list, some "Project Name" columns are text/numbers, and some are dropdown list.) The choices in value type are driven by the many teams specific needs. This creates…
-
How to have users only able to see and edit rows assigned to them?
Hi We have a number of sheets spread over different workspaces. We only want the users to be able to see and edit tasks allocated to them. We do not want them to be able to see information on sheets that is allocated to others. Initially I thought that I could set up a sheet(s) and allocate rows to a specific user. I was…
-
View options of Reports in mobile devices
Hi On a mobile device, the view options of Smartsheet Reports should be the same as those given in the view options given in the Sheets. Viewing the Reports at present is very inconvenient, in the absence of these View options (found in the Sheets). Please see the screenshots below for reference. Report View options (on a…