-
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…
-
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…
-
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?
-
Reorganizing the order things appear in Workspaces
It would be really helpful if we could reorganize the sheets, reports, and dashboards in Workspace. Currently it is set up alphabetically, which is really messy for my purposes, and I would love to be able to move my guide dashboard to the top, even though its name is not alphabetically first.
-
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?
-
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…
-
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…