-
Is there a quick way to identify or List all the Smartsheet Links?
Hi There I have a worksheet that I have inherited, and need a way to identify all Links from a cell in other sheets. Is there a report of function on Smartsheet for this? Thanking you in advance for your assistance. Warmest Regards Dickson
-
Keyboard shortcut to delete a row
Hi Everyone, I am used to working in excel and using keyboard shortcuts to navigate my sheets without having to use a mouse. Is there a keyboard shortcut to delete a row? if not can how do I let the product team know to add this to the development queue? thanks!
-
Allowing the Lag days in the predecessor field to be elapsed days
I've run into this issue where by the days I want a task to lag by is an elapsed number. E.g. Predecessor 380FS + e90d. The elapsed day function works well in the duration field.
-
Feature Request - Authoritative TODAY() functions
Context All Automations run on sheet owner time (in my case, Pacific time). Sheet columns generally use universal / UTC time in the backend (i.e. Created, Modified columns – so the time stamps are authoritative). However, the Today() function populating the Day column for the workplan is relative to the time zone of the…
-
Collaboration in Smartsheet (Saving)
Hello, I am just wondering what is the best way to work in collaboration on smartsheet. Currently when multiple users are working in the same sheet and one clicks save the other users data is lost! How do I prevent this from happening. What is the best way to guide the teams on how to work with each other effectively.…
-
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…