-
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…
-
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:…
-
Report not populating with formula column data?
Hello, I have a group of sheets that populate a report with date data. One of the date columns is a formula column that is constant through all of the sheets, used to track various processes to calculate a target end date. For some reason, the data appears on the sheet but does not populate on the report. It appears on the…
-
Dashboard Issues & Privacy
I have a master data sheet with data on it for 5 different clients. I've then created a series of reports that filter information for each client so they can view their own data without seeing everyone else's data. But I can't give them access to a report without giving them access to the source sheet. So I created a…
-
Missing Reports on a Dashboard. Then suddenly appears after refreshing. Then missing again.
Hi everyone, Have you experienced being haunted by a Report widget within the dashboard? Our Clients were complaining that some tables within the dashboard suddenly went missing, but after refreshing, it will appear and then gone again. This is my first time encountering this, and I've already raised a ticket to Tech…
-
Allow report widget to show calendar view
At the moment, dashboards, it is not possible to have a report showing with a calendar view. This would be a great help for user needing to see data in a calendar format.