-
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…
-
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…
-
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.
-
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…
-
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…
-
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?