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 …
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 th…
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 co…
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 …
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/t…
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.…
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 calcu…
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…
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 , 1…