Is there a way to show how many hours passed from the time the form was submitted/created to the running/current time and date? I am trying to show the running hours lapsed while the entry submitted i…
Hi all, I'm having trouble calculating an average duration of a time to resolve per quarter. This information is in two columns on a sheet: Time to Resolution (data type Duration) and Incident Year/Qu…
Hi all, I am trying to track time for each task in a gantt chart by using the formula (=Start@row + ""). This formula displays the date and time for each task as shown in the picture below. The proble…
Has anyone built a WorkApp where it can be used as a timeclock to track hourly employees time capturing GPS coordinates? Are there any demos to follow to create it?
We are working on a sheet to show the avg time spent on our tasks and we figured out how to time track as Smartsheet does not yet allow time tracking. Our solution was when someone selects "in progres…
I am trying to calculate the hours and minutes between a start and and end time. Firstly, what column type should the start and end time columns be, secondly, how should the time be written and thirdl…
I am trying to create a formula where if a Green Circle symbol drop down is chosen, then it records the time from the Date Modified Column. I keep getting invalid data type. Can someone tell me where …
Hi, I'm wanting to create a timesheet where 1hr = (ex.) £10, and hours can be input by an individual and the smartsheet will work out how much they are owed. First calculation to be row, 5hrs = £50, s…
I am trying to find the sum of the total duration of hours worked. When I use the formula =Sum(Children()), It comes back in with a "0" value. I tried adding a column to convert the "Duration" to an a…
Hello, I would like a formula to calculate Duration (in hours) using the Start Date, End Date, Start Time, and End Time. I would like to keep the Time in 12-Hour format if possible. Any formula sugges…