-
Resource Management Tracking by Hour
Smartsheet, here is my plea: Please add functionality to track time in schedules and resource management. In order for our growing organization to continue to leverage the power of Smartsheet and the connected Resource Management tool we need to be able to track tasks and resourcing down the hour level. This would be a…
-
Help with time calculation (total hours)
I'm desperate for calculating hours help 😩 I've created a report sheet for incidents in our department. These are submitted using a form and the incidents are managed by several people. The idea is that depending on the severity of the incident, we should alert the incident owner so they can update the status and leave…
-
Elapsed time from a system column to the current datetime
Hi guys, I need some help to calculate the hours and minutes have elapsed from a system column (which is the ticket creation date) to the present date, not sure if it is possible to use TODAY() formula. Here are some screenshots of what I have so far, but seems like the minutes calculation is not working. The ultimate goal…
-
Formula to track training by hours and minutes not days
We need to track all training by hours and minutes, not days, and I can't find a solution to be able to calculate this with a formula. Anyone able to help? Thanks!
-
Can time be automated by hours in a Smartsheet column?
Hello, for a few days I have been trying to automate time, not by days (because in smartsheet automations time is automated in days when recording a date) but in hours, so that through automation or a formula, a time can be recorded when a cell is modified, and at the same time those hours can be operated on, adding or…
-
Thanksgiving Dinner
I have a colleague looking to demonstrate the power of Smartsheet for project management and task management. She is trying to create an example of the task management and predecessor functionality using a typical American Thanksgiving dinner. The issue is Start and end date are only able to be calculated in days from what…
-
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.
-
How can I log/Add hours to a running total each week?
I would like to track hours each week. We have an automated update that goes out weekly and will ask how many hours were spent on each project/task. I would like to add these to a running total of hours. Bonus points if I can have the "Hours logged this week" zero out after it is added to the actual hours column.
-
Can Smartsheet drawdown hours used and hours remaining in a report?
I'm creating a higher level report that summarizes data from a Smartsheet. This Smartsheet contains the number of hours staff are assigned to in one column. I have an allotted number of total hours that staff can draw from. I'm wondering if there's a way that I can add the total number of hours they can use to the…