-
Column Formulas
Hello, I found this formula to convert time into military time but I would like the formula to be a column formula, so it automatically updates. It looks like I'm not able to convert it from a cell to a column formula however, any suggestions? =(VALUE(LEFT([Modified Time]@row, FIND(":", [Modified Time]@row) - 1)) -…
-
Cycle Time - Converting minutes to hours and minutes
Hello, I am trying to convert total minutes to hours and minutes but am having problems. I am using the formula below, but in some instances it returns a number with 4 digits in the seconds column. =INT([2023]@row / 60) + ":" + MOD([2023]@row, 60)
-
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…
-
"Substitute" Column Formula Inconsistency
Hello, I am using the column formula below to extract the time from the "Created Date" column. =SUBSTITUTE([Date Submitted]@row, DATEONLY([Date Submitted]@row), "") However, you can see in the screen shot below that it doesn't always work. Is this a bug?
-
Can you use the TIME function to calculate the difference i.e. duration between values in 2 columns?
Hello, I've previously used the many pointers and guidance on the forums for coming up with solutions that help calculate time and duration between columns using a range of different helper columns.. I've never used the TIME function before, but I'm hoping I can use this to try and save having to add multiple helper…
-
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…
-
Calculating time
Hello All, I'm a new user to Smartsheet and am trying to figure out the formula for calculating time. I have a start time column and an end time column and am trying to figure out the formula to calculate the amount of time in minutes. Any help would be appreciated!
-
Office Clinic Patient Registration Booking
I am looking to set up a booking system for a downtime project to be able to use in our offices (clinics). I would like to be able to see the rooms for that location and the availability for each time slot. Ultimately if a patient checks in they would then be assigned to a room during registration. 2. Is there any…
-
Trigger a Checkbox when the System time matches a Service Level Time
Our internal customers can submit requests to expedite a process to meet a customer's deadline. These requests should be processed within three hours of receipt. Currently, I can add three hours to the creation date and time to fill in a Max SLA Field. Once that future time (Max SLA) is reached (matches the system time), I…
-
Time Difference Calculation Using Military Time
I am struggling coming up with a time difference calculation smartsheet. I have two text fields, one called From and the other To. Users are to input time in a military format (exp: 07:00, 13:00) and then the calculation should fill my Duration field with the difference between those two times. Can this be done without…
