-
Calculating a running tally of time
Greetings colleagues - I'm stuck and could use some help. I have a checklist that needs to calculate the Start and End time (hh:mm) given the first start time and duration in minutes for each step in my checklist. All of my columns are Text/Num. I read countless posts and got the Row@row-1 set up so a helper column will…
-
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…
-
Zeitraum zwischen "Heute" und einem gesetzten Datum berechnen (excl. Sa/So/Feiertage)
Ich suche nach einer Formel die mir, ausgehend vom heutigen Datum und dem Eintrag in einer Spalte "Ende" die Anzahl der verbleibenden Tage berechnet. Ich verwende folgende Formel: =TODAY() - Ende@row. Die Anzahle der Tage werden dargestellt. Nun möchte ich jedoch die Anzeige auf die Arbeitstage reduzieren, d.h. Samstage…
-
Need help with tracking time
I am barely new to Smartsheet but I can see the potential of helping me with my job duties, I work as a service dispatcher, We have been running out of Microsoft spreadsheets but I don't know a lot of coding and VBA so if I figured out how to obtain the average time in when the tech arrives on-site versus the time back to…
-
Identify Time Zone
Hi; I have a sheet that users captures information in, I have a column that records the modified date time, so the column is type of modified. Example Sheet1: Descrption , value , ModifiedDate abc , 123, 2024-01-01 10:50 <--- date time shown in Sheet ex GMT+2 Example Sheet2: Item Name , Value, ModifiedDate abc , 123,…
-
Merged: record time in automation
This discussion has been merged.
-
Put a pause on calculating SLA
Hello, I manage a RAID log for my team. I want to calculate SLA for each issue. I don't want to calculate if the case is checked in IT column and if it's status is "Cancelled", here is my current formula: =IF(AND(Status@row = "Cancelled", IT@row = 1), 0, IF([Closed Date]@row > TODAY(), NETWORKDAYS([Created on]@row,…
-
Daily Time Tracking
Hello All, I am working on a Smartsheet that will allow us to calculate time worked over the course of a day for a group of union employees. I've built out some of the functionality but am running into trouble when it comes to employees working from one day into the next. I currently have several groups of columns that…
-
Invalid Value in Date / Time Calculation
First some background, this is not a consistent outcome, and there is more than a single calculation involved. The Hypercare Ticketing system calculates SLA times and was a bear to build as it is based on Ticket Priority and time. We don't run 24 hours, so had to calculate over 'next day'. That is just the background. What…
-
Best Practices/Work Arounds for the lack of "elapsed" and "months" options
I want to open the discussion in this industry forum because I'm certain this would be a group of folks that regularly encounter this short coming. The inability to put "edays" in the predecessors column leads me to a ton of extra rows that serve no purpose other than being a way to get "# edays" in the duration column so…