-
Allow display of destination sheet full name in the Edit Automation dialog when moving copying rows
This is a simple request to allow visibility to see or display the full name of the destination sheet in an existing automation. Here is the use case: 1) I have created an automation whose action is to move or copy a row. 2) The name of a destination sheet that is selected is longer than what displays in the Edit…
-
Time Column Property
Similar to the other column properties, but restrict a column to time (whether 12 or 24 hour format) and be able to generate formula based on beginning and end times and other entries.
-
Formula for rolling up children status to parent rows
Hello, I am trying to simply roll-up my children status' to their parent row. When using this formula: =IF(COUNTIFS(CHILDREN(), @cell = "Complete") = COUNTIFS(CHILDREN(), OR(@cell = "", @cell <> "")), "Complete", IF(COUNTIFS(CHILDREN(), @cell = "Not Started") = COUNT(CHILDREN()), "Not Started", "In Progress")) I receive…
-
Change "end date" based on status changes
When an end date is used in a dependency setting, you can't use automation or formulas to change it. However, this is when it is critical (pun fully intended)! When someone marks an item as Completed status, it would be helpful if the sheet could update the End Date column to the date it marked completed. For dependencies…
-
Creating Expense Reimbursement Request
I've been tasked with creating an expense reimbursement request for our employees to use. We currently use an Excel spreadsheet but then have to manually get approvals. We're trying to move that to Smartsheet to automate the process. I can create a very simple form for 1 expense item. However, sometimes an employee will…
-
Auto sort
Checking if there's been any movement on having the sheets sort by data in a column as I see it's been requested since at least 2016. We have sheets that are sorted by a date that could be 2 days from the day entered or 12 months from the day entered. We also have a filter to hide past dates. Data is being entered via form…
-
Right Click new Tab or window
Enable Standard Browser shortcuts - Smartsheet has disabled some standard browser functions. This is one of the top 10 complaints I get from users. you can not right-click and open anything in a new tab or window. You can not hit Ctrl+Click to open in a new Tab. Mainly the left toolbar. I would like to see all standard…
-
Does Smartsheet integrate well with any barcode generators?
I'm heading the inventory control department at our lab and we'll need to be able to track parent and child samples throughout the lab via scanning them at which ever work station they happen to be at. Any recommendations for a good barcode generator that works well within Smartsheets would be appreciated!
-
ISCRITICAL for Parent Tasks
Currently, Critical Path does not propagate from a Child to the Parent Row. Create a functionality or a new formula for ISCRITICAL to show on Parent Tasks, maybe even up through a specified number of levels in a hierarchy.
-
Calculate time between start and stop
Hello - I thought this would be an easy formula but it keeps returning at invalid or unparsaeble. I am trying to find the difference between stop time and start time - when I enter the Stop time on line 25 (2:44) and then I enter the next start time on line 26 (6:33), it automatically calculated "Time Between Cycles" as…