-
Nested child cards/time management
Hi everyone! I need help with a couple of things please. For our monthly KPI reports, we have to track how much time we spend on each task. How do I add subtasks to be the main task (i.e. total hours spent on that task overall) I would need to see total hours spent on the task overall and total hours spent on each sub-task…
-
Time and Date calculation
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 is still in the "Pending Status" I have the following column available I wanted to show the current duration in hours that…
-
Average Time for Chart
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/Quarter (dropdown list). I've looked in the time articles and downloaded the formula template, and still missing the right…
-
How to change and edit default time in Gantt Chart ?
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 problem is its assigning the default start time for a task to 8:00 am and I am not able to change it. The project settings section…
-
Use Smartsheet as a Payroll Time Clock
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?
-
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…
