I am wanting to view the amount of time it took my team members to complete a form. I know it can be done, but am having a hard time figuring out how. Any help would be appreciated.
This may or may not be possible with smartsheet functionality, depending on what 'time to complete' means to you. Do you mean from the time someone clicks the URL to summon the form to the time the form is submitted? Do you mean from the time that form is submitted (as the initiation trigger for a process) to the time that work process is finished? If the latter, are you anticipating the duration to be minutes/hours or days/longer?
Create and edit formulas in Smartsheet
Formula combinations for cross sheet references
Smartsheet functions list
Hello Requesting a formula (column) to return a date to a specific week but is always on a Tuesday. My spreadsheet is a work back schedule to a specific date. Launch date occurs on any day of the week but I need minus 3 weeks to land on Tuesdays. Thank you
Hello, I am using a formula to extract a date from a string of text. It appears to be working, but if I leave the sheet and come back later it continually reformats the date from MM/DD/YY to YYYY,MM,DD. The target columns are formatted as dates, and the original column is a dropdown list. I can change the target column…
I have a sheet with a resource count than can be blank or contain from 1- 5. For each resource count there is a corresponding work effort in the next column, separated by a comma (see table below). I am trying to extract the work effort totals into separate cells WE1 through WE5. Objective: Using formulas found in the SS…
©2024. All Rights Reserved Smartsheet Inc.