-
Timeline view in reports, now generally available!
October 29, 2025 Users can now choose to view their reports in timeline view. Please note: Timeline reports will reflect the source sheet(s), columns, filters, and groupings applied to the rest of the report. To change any of these, simply switch the report back to grid view. If you want to edit the Start Date or End Date…
-
Share a Report sheet without needing to share the Source sheet
I have a source sheet where data from multiple vendors are present. I would like to share vendor specific data from the source sheet to each individual vendor without sharing sensitive data from the source sheet (data from other vendors). Currently I have a Report sheet that is pre-filtered to the specific vendor, but…
-
Provide users with the ability to Print a Grouped Report
Per the 1.5 years of queries being made, I believe there is suitable interest from the Community that Smartsheet provides the basic functionality of being able to print a Grouped Report. The system currently reverts the Report to a basic Sheet when Print is selected. This is not suitable or acceptable. We've stopped…
-
Ways to avoid 25000000 formula cell reference limit
We have a sheet that we use for time tracking for some of our projects. We have about a dozen people supporting projects and they may log their time multiple times a day. I have a SUMIFS formula that adds the duration for each client project. Formula: =SUMIFS(Duration:Duration, [Client ID]:[Client ID], [Client ID]@row ) I…
-
How can I combine grid data and Sheet Summary fields into one editable grid sheet?
I have a Sheet Summary Report that pulls data from 48 individual sheets — this includes both the row-level grid data and each sheet’s Sheet Summary fields. I want to have all of this information (both grid and summary data) together in a regular grid sheet, so I can format it, add formulas, and use it in dashboards more…
-
why wont my sheets group properly in my report
I created a report to try and get all my projects tasks organized and identifiable by project. I have the report groups by work breakdown schedule sheet, but for some reason my latest sheet will not break out in its own group. in the image below you can see the sheet that is grouping is the template sheet, but the P-0100…
-
Proactive with Error Messages - Report
Is there a way I can be proactive about error messages that apprear on my various sheets, reports and dashboards? Like provide me some type of report, so I can go to those pages and get things fixed? I would not even know how to set anything up, as there are multiple sheets, reports, dashboards I manage.
-
Creating a formula that takes the total average of a row but excludes certain entries
I need to create a formula that take the total average of the row but doesnt include entries that are "N/A" "YES" or "NO" in the count. At present when ever those are entered the formula im using counts as "0" which greatly decreases the total percentage
-
Report creation
Hi There, Stupid question about creating report, I open one new report and select one of my create sheet like below screenshot: And I want to filter the columns to display, but I cannot select the columns in the original sheet The sheet content I choose: Wondering how to select the columns in the report from the sheet I…
-
Insert or Copy Photos to Reports
It's very easy to insert photo into sheet cell. You can also easily copy and paste photos to cells from the clipboard. However it does not work in reports - the only thing that can be done is copying and pasting the photos from the same report.