-
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…
-
Adding Calculated 'Report' Column into a Report
we need to make some calculations on summarized data in reports. such as summing up two or more column values or dividing two column's values in each other to get a percentage value from them. Calculation have to be functional not only in data rows but also in summary rows in a report. My suggestion is to make a calculated…
-
Smartsheet Report - Adding the same column several times with different filters
I'm hoping to create a report that includes the same column several times, but with different filters applied each time. That way, the report has multiple columns with different information displayed, but each column is pulling information from the same column in the base sheet. Wondering if this functionality exists!
-
Merged: Adaptive Height Report Widgets in Dashboards
This discussion has been merged.
-
Best way to compile rolling metrics for Dashboard Update
I'm working to build a dashboard that presents monthly metrics. I want the dashboard to automatically update to display the last 12 months' metrics. I have a metrics spreadsheet that calculates all the information for each month. I'm wondering if the best way to achieve this is to create a new smartsheet with a formula to…
-
Grouping in reports based on 4 variables
Hi Community Trying to work out best way to produce a report based on 4 variables…which is just one more than the max in reports. I can't be the first one to have this conundrum and I would be keen to understand how others have resolved it. Columns, in the hierarchy I would like to report are:…