-
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…
-
Report Builder - toggle column list order
It would be helpful to have a toggle (or some other way to make a choice) in the columns section of the report builder: Alpha or Sheet Order. Most reports mirror the layout of the underlying sheets to some extent, so it would be helpful to have the column list sorted in the same order as the columns appear on the sheet…
-
Edit recipients in scheduled email reports
I have many reports that get emailed out on a defined schedule and often the recipients need edited. Unfortunately editing recipients is not an option (only editing the recurrence schedule), so I have to recreate the entire schedule to remove or add any recipients. It is very tedious and time consuming when you have…
-
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.