-
Tracking the Specific Time of a Cell in One Status
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 changes with helper columns, I really cannot figure out how to do so specifically for one cell. Any recommendation on how…
-
Sum Time Difference in Quarters between 2 Columns
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 to calculate 12 hours If Start Time = 1845 and End Time = 0600, which falls on the next day. I would need it to calculate…
-
Smartsheet bug? Time / Rounding formula error
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(LEFT([Start Time]@row, FIND(":", [Start Time]@row) - 1)) + VALUE(RIGHT([Start Time]@row, 2)) / 60), " ") And then using the…
-
Dashboard Element, Count By Created, Grouped by Time (Hour)
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 create a graph that totals all calls by time, specifically the hour of the day. In Excel I create a pivot on the Created…
-
Put modified date into a Summary Sheet
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 time the last update occurred. Summary fields don't have all the options as normal, but very simply I want to take the data…
-
How to calculate time spent on a project using the Time Function?
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 (the difference between the start and end times). I found the Smartsheet article on the Time Function, however, their…
-
Resource Management: use : to enter time in minutes
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 without having to work it
-
Can Smartsheet drawdown hours used and hours remaining in a report?
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 that staff can draw from. I'm wondering if there's a way that I can add the total number of hours they can use to the…
-
Workflow Automation for a 2-week notice email
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 do that I originally configured trigger to two weeks before notification date and set my other two conditions but then…
-
Count weeks in a Cycle
I know there is a function for counting weeks based on the start of the year. Is it possible to count weeks from a specific start date, instead of from January 1? For example, I might have 12 weeks in a cycle of a project, and would like to show (on a dashboard) that we are in "week # of 12 weeks" in a specific cycle.…