-
Dynamic Report Filter
Is it possible to have a report base a filter on a cell value?
-
How can I log a timestamp of a cell change?
I want to add an automation rule to write a timestamp of when a cell value changes, I know I can use the "record a date" automation to get the date but is there any way I can get the exact timestamp similar to the "created at" field in form responses? I am also looking into a way to implement it using the API and there…
-
Conditional Logic for Header fields in Forms
Hi all, With the new update to Smartsheet forms, we are able to add conditional logic to designated fields within a form. However, I noticed that while you can set logic to only populate designated fields when a certain option is selected, the headers of the fields that are NOT designated under that logic still appear on…
-
In a Gantt with many rows, how to color a date range that spans all rows in a column?
In other words, I have a developed Gantt with many rows. There's an event that I'd like to track in the Gantt that occurs over the course of several weeks. I would like to highlight that date range but not just have it on one row, I want it present on all rows in order to show impact on all activities.
-
How to Import MS Project File into Smartsheets, but with the Time stamps from MS Project?
When I try to import MS Project File into Smartsheets, it automatically treats the import as a project and hence the result only appears with the Start Date and Finish Date, and I lose the time stamps in from my MS Project File. I also tried taking an export of excel file first from mpp., but as I export to Excel, I lost…
-
Report Grouping Summary Rows in Dashboard & Attachements
Is there any update on when reports might keep the grouping/summary rows when sent as an attachment or displaying on a dashboard? I remember hearing this was 'in the works' back in February.
-
Unhiding Individual Columns
Hello, Having to unhide all columns at once can be overwhelming for new users. From a developer stand point, it's horrible. I usually have to unhide all columns to develop automations and procedures through multiple sheets and reports. Just to properly set up a lookup function can be difficult for new employees who haven't…
-
Hidden as a column attribute
It would be great if we could have a 'Hidden' checkbox attribute added to the Column definition in Sheets (with Name, Column Type, etc.). In many cases when we have Sheets with multiple helper columns that we would rather be hidden, I find that it is a time-consuming task to re-select the same columns to hide again after…
-
Default Sort setting
Hi, How can I set a default for sorting in a sheet? For example, I have a system "Modified Date" column, and I want the sheet to ALWAYS sort by descending order, i.e. the most recently modified on top. I want the sort setting to stay even when refreshed, and when I'm editing in the sheet that the modified row will…
-
Auto Sort
Hello, Is there any way to create automation that will automatically sort a sheet when a cell is updated or changed? Thank you, Sean