-
How to get actuals confirmed in Resource Management to update actual work in Smartsheet?
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…
-
Tracking 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…
-
Resourcemanagement Time tracking Week Number
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.
-
Issues with TODAY() and daily reporting
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…
-
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…
-
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…
-
Granular time sheeting in RM should line up with child rows
In RM you could require category when entering time. However, these are created in RM and have nothing to do with rows in Smartsheet. This should be synced to Smartsheet by virtue of some additional field sync or tagging mechanism so that granular data can be pre-mapped from Smartsheet, in the vein of…
-
Support and Sync allocation in hours from Resource Management to Smartsheet
We submit time projections by hour instead of by %ages. I am aware that RM sheet daily hours are converted to %ages to sync between RM and SS. However, hours are needed for calculations and dashboards at this time. We would like to see raw daily hours reflected in RM available for reporting in SS. Would it be a huge lift…
-
Merged: Auto timestamp
This discussion has been merged.
-
Record time against a project that I'm not assigned to
A problem came to light where a Project Manager (access level “Project Editor”) wanted to record some timesheet hours against a project that he hadn’t previously been assigned to. He accessed his “Time and Expenses” screen and clicked “report time for something else” but no options were presented, even when he typed into…
