Hi there. In part of my duties, I run a report that shows activities entered on a form from yesterday. We do achieve "yesterday" by using the following formula: =IF(DATEONLY(Created@row) = DATEONLY(TO…
Hi all. I am trying to simply and easily track the time in days a cell is in red status (General Health column in picture below) until it changes. Nonetheless, although we can easily keep track of row…
Is there a way to sum the time difference between two columns There is two columns "Start Time" and "End Time". If Start Time = 1800 and End Time = 0600, which falls on the next day. I would need it t…
Hi, I'm using the following formula to calculate the difference between 2 times: =IFERROR((VALUE(LEFT([End Time]@row, FIND(":", [End Time]@row) - 1)) + VALUE(RIGHT([End Time]@row, 2)) / 60) - (VALUE(L…
I'm able to quickly accomplish this in Excel, but have no idea how to achieve the same in Smartsheet. We have a call log where a new Created row is automatically generated on submission. I'd like to c…
I am trying to create a sheet that gets updated automatically every hour via data shuttle. I'd like to have a summary sheet tied to it that allows me to show some values and also show the date and tim…
Hello, I am trying to set up a time tracking sheet to track how our factory staff spend their time. I have "Start Time" and "End Time" fields in 24 hour format. I am trying to calculate the time spent…
As well as being about enter time 2.75 hours of time we would like to able to enter 2:45 for 2 hours and 45mins of work. This makes it easier for users to enter how long they have worked on things wit…
I'm creating a higher level report that summarizes data from a Smartsheet. This Smartsheet contains the number of hours staff are assigned to in one column. I have an allotted number of total hours th…
Hello All. I have a sheet that has staff name and their term date. I want Smartsheet to look at this sheet daily and send an email to HRC with details of staff whose term date is 14 days from now. to …
