-
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…
-
Issues with Fieldwire integration and reports made from those grids
My team uses Smartsheet for milestone task tracker and then Fieldwire for all things engineering drawings. When boots are on the ground, tasks are created in Fieldwire since you can tag drawings / portions accordingly. In the past six months, they introduced a Smartsheet integration where it can create and every 24-hours…
-
Better UX for Sorting in Reports
When sorting rows in a report it would be nice to be able to drag the sorting criteria up or down so that you don't have to delete and remake it if you placed it in the wrong order or want to change the order.
-
Help on getting the SHIFT from a time
Hi, I m trying to extract the shift where and inspection is conducted. primary time source is CREATED DATE column, than I extracted the time using the formula " =TIME(RIGHT([Inspection Date]@row, 8))" however I can't figure the approach to get to the Shift if I am hoping a return of 1, 2 or 3 from: Shift 1 = 0600 - 1359…
-
The sheet you are attempting to access is no longer published.
I published a report. For over two months now. I shared the published link to people. They hav been able to view the report since then. But now they are getting the message "The sheet you are attempting to access is no longer published. Please contact the sheet owner." I have checked the sheet and everything is in order.
-
Report for past due tasks
I'm creating a report to show past due tasks. I want the report to show tasks that: Are not marked completed and have a finish date in the past Are not marked completed and have a target date in the past I'm having trouble with the target date is updated to a future date, I do not want the task to show on the report if the…
-
Adding a last comment column into a sheet
Is there a way to add a column that updates with the last comment entered into the conversations from that row? For example: If I entered notes from a call that I had with a client "conversation went well, will follow up" that note would populate into a column on that same row labeled last comment or update. This would…
-
Dynamic View Not Allowing Temporary Sort
I have a dynamic view that is pulling from a report that contains two source sheets and does not have any default sorting. When I try to temporarily sort the DV by date, it loads and refreshes as if it is sorting the data, but nothing gets sorted. All of my columns in the DV are behaving this way. What is going on?
-
Viewer Vs Paid Membership?
Do you have to have a paid Membership on Smartsheet's to access a link in a worksheet? Or Can you just be a Viewer and still have access or open a link on a smartsheet?
-
Summary sheet values don't update in dashboard without entering source sheet?
I have a sheet summary report on a dashboard and oftentimes the values will not update unless I go into the source sheet and manually save the updates. For example, the WEEK TIME OFF value often will not update week-to-week unless I go into that contact's sheet and save. I have tried adding a daily Chron automation…
-
CEO
How do I update my users on smart sheet? I downloaded my smartsheet user reports and there is old employees I have to delete?
-
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…
-
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…
-
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
-
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.
-
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…
-
Combined Report of Sheet Names
Is there a simple, easy way to get a report that just has the links to the different sheets (using the Sheet Name column) that have been added to it? I've done this before with my own sheets where I filter to something consistent in each sheet (ex., I use the ancestors and hierarchy in all of my sheets so I can just pull…
-
Controlling record visibility in reports using Smartsheet Groups
This solution allows you to combine the "Current User" filter and Smartsheet Group membership to filter records based on who is a member of a Smartsheet Group. Solution overview Python Create scheduled task to run daily Python script that pulls all Smartsheet groups and group members and saves as CSV on SharePoint site.…
-
レポートで「End Date」列が編集できない件について
質問： レポート上で「End Date」を編集することは不可能なのでしょうか？ 状況： Smartsheetで作成したレポートにおいて、元のシートの子タスクのみを表示する設定にしていますが、「End Date」列が編集できません。以下の状況です。 元のシートでは、子タスクの「End Date」は編集可能です。 レポートでは「End Date」列が関数として表示され、編集できません。 「End Date」列はプロジェクト設定に使用されており、ベースライン取得にも利用しています。 「Start Date列」はシートとレポートにて編集可能です。 列の設定画面には「This column type can't be changed due to…