-
Average days in a status & oldest status date
Hello - I have a client data sheet, and one of the columns is New Account Status. I've added a column called Misc. 1 that tracks when the New Account Status is changed to Ready to Open. I have a separate Metrics sheet to track a variety of metrics on. Making any changes to the main client sheet (changing column names,…
-
Ability to duplicate dynamic views
We need the ability to duplicate (copy) an existing dynamic view to other sheets. We use templates and Smartsheet Control center, but when creating a new sheet (using SCC or Save As New) the dynamic view(s) are not also copied/duplicated. This creates a LOT of manual re-work. It'd be great if, from the Dynamic View…
-
Created Time
So I am trying to extract the timestamp from the created date column and its making me feel crazy. The TIME() function help file describes a formula that should work exactly how I want - however NOTHING as described works at all. (https://help.smartsheet.com/function/time) =TIME([Date Created]@row) returns "INVALID DATA…
-
Timeline View - Printing
Would it be possible to have the printing option for the Timeline view?
-
Ability to hide row conversations/comments and/or attachments on published reports
Reports are great for sharing specific information from teams to leadership or external partners. However, it is a huge limitation for published reports not to have the ability to hide conversations. Conversations are a great feature for internal teams to be able to communicate on specific line items within a sheet, when…
-
Is Linking sheets feasible when there is a maximum number of linkages
HI I have created a smartsheet for a plumbing business, the boss wants a master one where he has financial info which I have as the master one and then a working one for the forman that updates the master but does not have the quoted or accepted price. Is this a dumb thing to do since the is a cap on linkages. Is there a…
-
Can automated email come from a specific email address?
We created a tracker for the Records Management team and need all emails coming from the tracker to come from the email address associated with the team. Is there a way to have all emails come from this specific email? I see options for the owner or from general smartsheet but not an option to have it come from a different…
-
Export does not match filtered results in the UI
I'm trying to export filtered results and the export does not display the same results as what's displayed in the UI. Please see the screenshots and let me know if there's anyway to resolve this.
-
Dynamic view entry formatting causing issues on source sheet
Hello, I have a Dynamic View set up to capture dollar amounts, the source sheet is formatted to currency for these cells. The issue is the data is mostly entered using copy/paste which is preferred to prevent typing errors, and the dollar sign is copy/pasted along with the number. When pasting this way it fills in the…
-
Ability to save as new more than 100 files so the interactions remain
Currently there is a limitation to save as new and/or copy only 100 files at a time. This means if you have a workspace with more then 100 files that need to interact with each other for the dashboards to remain intact, you can't do it. You would need to copy it in pieces and repick reports, data for widgets, etc.