-
Time taken to complete task
HI All, Apparently, i found this ticketing system fitting perfectly to my needs but i am stuck in the last 2 columns. End date and Duration(days and time taken). End date must come automatically show when status change to complete. Duration must show difference between created date+time and end date+time. how can i solve…
-
What is the best template to create a time tracking tool?
I need Task, Note, Priority, Ststus, Created by, Assignee, Start date and time, End date and time, Duration in days and time. And a dashboard to see an overview.
-
Is it possible to pull an activity log that includes a cell history report with time stamps?
Hi there. I am relatively new to Smartsheet and have been enjoying all the tools that this platform offers, but I want to see if I can make it work even better for me. I am essentially a process manager that sends reports to various stake holders via Smartsheet status changes The stake holders are dependent on the…
-
Time Tracking within Smartsheet
Our organization is looking to utilize Smartsheet for project management tracking and would like to have it track time entries to account for the whole week of work (projects and non-project work). I would like to know how others are doing this. I know Smartsheet has the Resource Management planning tool, but I have not…
-
Time slots on calander?
We have a machine we want our coworkers to start requesting, daily and hourly. So if Joe wants to use the machine, he could go to the calendar and see an empty time slot between 1pm-2pm and he would be able to block that time out. Does smartsheet have anything like that? Kind of like an outlook calendar
-
Time Approval in Resource Management
I have created a placeholder in Resource Management that gets time assigned to it for a project. I am the approver assigned to the placeholder for all hours associated with it. Right now, all the time that is being assigned to the placeholder is logging itself as unconfirmed as each day goes by because I have not…
-
Auto fill date and time emailing the wrong information?
Greetings, I set up a very simple form pictured below where someone could select their name from a drop-down and hit submit. On the back end, I have a column called date which enters the date and time of the submission. This information is then emailed to myself and a manager with all of the information in the row. When I…
-
Tracking flight times (hours, minutes, AM/PM) in Smartsheet
We have a process that we are automating and the only thing remaining to figure out is managing time for flights. We have to manage flights for hundreds of individuals and need the travel planners to enter the flight time; hours, minutes, AM/PM or even going to a 24-hour clock and entering that (3:54 PM or 1554). Does…
-
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?
-
A = SUM(A,B) - possible?
Hi Looking to create an automation that creates a cumulative total. E.g. if "time entry" field changed then ADD "time entry" to "Total Time". Clear "time entry" Is this possible?
-
Desktop/Mobile App - Tracking Time in Resource Management
Hello, I am writing to submit a feature request to the product team concerning Resource Management. We propose the addition of a Desktop or Mobile Time Tracker, enabling our teams to log their time directly for various projects within the desktop or mobile application. Currently, the process of opening a web page, logging…
-
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 function Glitch
Hi, I noticed a strange glitch that occurs when using the Time() function. I'm basically trying to mimic a stop watch by calculating the duration of a start and stop entry utilizing the created date/time stamp. I have setup automation to move the rows that are entered as stop to another sheet. I extract the time portion…
-
Hours:Minutes:Seconds reported by consultant at $/hour calculated to the hr/min/sec used
I have a consultant who bills at the hourly rate down to the Hour:Min:Seconds time used. They provide us with Time in this format 1:13:51. How do I take that time and multiply it by the rate to give correct cost per time in USD?
-
Has anyone used Smartsheet to create/track timesheets for employees/time off banks?
My org does not currently have a timekeeping system and had been using paper timesheets up until 2020. During Covid they had mish-mashed together an Excel sheet to be filled out and submitted to a smartsheet (created for each pay period). This smartsheet template that is remade each week is really only a notification…
-
Why can't I turn off pre-populated timecards?
This is an issue with our auditor that we are pre-populating timecards for resources. How can I turn off this functionality?
-
How to get actuals confirmed in Resource Management to update actual work in Smartsheet?
We have Smartsheet & Resource Management implemented enterprise wide. While the work estimated from the integrated Smartsheet sheets is prefilling the time & expense timesheet in Resource Management, the actual confirmed hours do not feed back into Smartsheet as Actual work. We would like to have a way for confirmed time…
-
Tracking Time
Hopefully this post will help someone looking for a solution for dealing with time in Smartsheet outside of Resource Management. (Bolded the summary for quick access) I've recently run into an issue with a project. We are maintaining a lot of our data in Smartsheet, but a recent project got brought up about wanting to…
-
Resourcemanagement Time tracking Week Number
We have received the request from the engineers to add the week number to the date on the time tracking sheet. This is convenient as the overall time tracking report also shows resources by week number.
-
Issues with TODAY() and daily reporting
Hi there. In part of my duties, I run a report that shows activities entered on a form from yesterday. We do achieve "yesterday" by using the following formula: =IF(DATEONLY(Created@row) = DATEONLY(TODAY()) - 1, "Yesterday", "Not Yesterday") In using this formula we have noticed some alarming discrepancies. Reports with…