-
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…
-
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…
-
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. Has anyone used it? And/or has anyone found a work around?
-
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?
-
Merged: record time in automation
This discussion has been merged.
