-
COUNT(DISTINCT(COLLECT to count unique values based on multiple criteria
Hi, I'm trying to count the dates we've worked on a job site, but we have multiple ones. Of course, at first, I'm trying to calculate just for one criterion. So far, I've tried using the Sheet Summary: =COUNT(DISTINCT(COLLECT(Date:Date, [Site ID]:[Site ID], "CUPERTINO"))) As per my database, I have 80 entries for…
-
Resource Management analytics report showing phase dates
How do I run a Resource Management analytics report to show phase dates? It only seems to show the total project dates.
-
Has the report grouping functionality changed to allow more than 2500 lines?
Hello, We have some regular reports that we pull data from that are grouped and have over 2500 lines. These reports have always hidden the lines because grouped reports can't show more than 2500 lines. As of this morning I noticed that now my grouped reports have multiple pages at the bottom and I can see the lines within…
-
Dashboards Randomly Displaying Blank Reports
I have encountered peculiar behavior with my dashboards over the past month. My reports are randomly displaying as blank. When I refresh the page, it's a hit or miss on which reports display. I have to keep refreshing until the report I want to see finally displays its data. Recent changes: I've added a substantial number…
-
Reports appearing blank in dashboards.
Is anybody else experiencing issues with reports appearing blank (or not appearing at all) in dashboards? Nothing to do with permissions as this is being experienced across the board, even by my team who owns and builds the dashboard and relevant assets. Sometimes they title of the report and the column names appear, but…
-
Reporting: Multi-Select Data, Best Practice?
I have a multi-select column I'm trying to count instances of for each quarter of each year. I created a make-shift report using a sheet and I'm looking for help to determine if there's a better way to do this. Report I created: I've duplicated that sheet into more columns so I could share the formulas I am using. The left…
-
DataMesh from Report Still Pulling Filtered Rows
I have a DataMesh that is meant to pull rows from a report that excludes rows with certain criteria. Unfortunately the DM seems to pull all of the rows from the report and ignores the report's filter. Anyone else experiencing this or found a solution?
-
Asset register report/dashboard showing latest child row data only
Hi there, I'm trying to build an asset register in smartsheet with parent rows for the initial addition of the asset record and then child rows to record any future tickets logged against that asset and the corresponding asset status (so the asset history can easily be tracked). The objective is to provide customers with a…
-
Report Builder Query - Grouping
I have created a report, but for some reason I am unable to group by the Assigned To field, which is not displayed in the drop-down options, even though the field is displayed in the report. What am I doing wrong?
-
Adding columns from different sheets to the Report
I have a Report that i have been using for some time, and I add and remove columns from the source sheet with the formula and color-coded status. I would like to include the column from a different sheet, also with formula and color-coded status. All it does it pasts the collum and the title but no cell context (column…