-
Time entry Smartsheet vs. Excel
Hi All, Problem - I have a VERY simple Excel spreadsheet for collecting hours and it has been working fine, but now I want to use some functionality I know that will be easier to complete if I move the sheet to SS. I exported the sheet to SS and my very simple formula no longer works. Goal - Have SS return the the…
-
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.
-
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…
-
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!
-
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.
