-
Trouble with Time Tracking
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 progress" the row will be copied to another sheet. In that sheet we have a formula to grab the time from the created date and…
-
Calculating Time
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 thirdly, what formula would I use to calculate the difference between the two columns.
-
Clocking In / Out
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 the error is in this formula? =IF([Clock In ]@row, "Yes", TIME(RIGHT([Date Modified]@row, 8)))
-
Calculating formula for total pay for hours worked?
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, second calculation to be the total of the column 5x £50 = £250. Is there a way to assign a value to a number e.g. 1 = 10, so…
-
Total Hours Worked
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 actual number and I am getting "Invalid Value." when using the AI recommendation formula of =VALUE([Duration]@row) Any…
-
Formula for Duration using Start & End Date & Time?
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 suggestions? I tried using a formula without factoring in the Dates, but the Duration for those highlighted in yellow ended up…
-
Has anyone figured out how to incorporate a timer?
My team is used to entering their time into Harvest which has a desktop timer. They start it when they begin a task and stop it when they are done. Although I've been told and read Smartsheet doesn't have a timer, I did find reference to one on Smartsheet's website.…
-
Time entry Smartsheet vs. Excel
Hi All, Problem - I have a VERY simple Excel spreadsheet for collecting hours and it has been working fine, but now I want to use some functionality I know that will be easier to complete if I move the sheet to SS. I exported the sheet to SS and my very simple formula no longer works. Goal - Have SS return the the…
-
MIN/MAX with Date and Time (Modified Date Column)
Hi all, This should be straightforward but I am stumped! How do I get the earliest (or latest) value including time from a Modified Date system column? e.g. I can get the date if I define my output column as type Date and use a simple MIN/MAX but this means the time is ignored. I thought about breaking the time and the…
-
Merged: Improve Automated Trigger Times
This discussion has been merged.