Is it possible in the Smartsheet Business plan to utilize a form to input daily hours by a team member that would add up all hours spent against a project? I was thinking of creating a "Time Tracking …
I have an escalation sheet and we're trying to get a report to show how many escalations over time. I was able to bucket them to show by month, but want it to show months that = 0 so it can show a tru…
Hopefully this post will help someone looking for a solution for dealing with time in Smartsheet outside of Resource Management. (Bolded the summary for quick access) I've recently run into an issue w…
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…