I have a consultant who bills at the hourly rate down to the Hour:Min:Seconds time used. They provide us with Time in this format 1:13:51. How do I take that time and multiply it by the rate to give correct cost per time in USD?
This discussion has been merged.
My org does not currently have a timekeeping system and had been using paper timesheets up until 2020. During Covid they had mish-mashed together an Excel sheet to be filled out and submitted to a smartsheet (created for each pay period). This smartsheet template that is remade each week is really only a notification…
This is an issue with our auditor that we are pre-populating timecards for resources. How can I turn off this functionality?
We have Smartsheet & Resource Management implemented enterprise wide. While the work estimated from the integrated Smartsheet sheets is prefilling the time & expense timesheet in Resource Management, the actual confirmed hours do not feed back into Smartsheet as Actual work. We would like to have a way for confirmed time…
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 with a project. We are maintaining a lot of our data in Smartsheet, but a recent project got brought up about wanting to…
We have received the request from the engineers to add the week number to the date on the time tracking sheet. This is convenient as the overall time tracking report also shows resources by week number.
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(TODAY()) - 1, "Yesterday", "Not Yesterday") In using this formula we have noticed some alarming discrepancies. Reports with…
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…
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…