-
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…
-
Start/stop buttons for timekeeping?
Hello! I am curious to know if anyone has a solution for stop/start buttons to record team members' time toward projects in Smartsheet outside of Resource Management. This is for a small team without access to any premium apps. When a new project is set up, it is added to a master Project List sheet, and manually added to…