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