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.…
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…
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 form…
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 int…
