-
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…
-
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…
-
Automations for time based requirements
Currently we can only use filter expressions and automation that are based on current day or previous day etc. Why can't we filter by past hours or other similar terms? It would add so much functionality to Smartsheet in its various functions, such as project for one when assigning task durations by hours or to filter…
-
CTC hours used by the task and role month-wise and visualize it
Hi, I am trying to figure out how to calculate the CTC hours month wise used by the task and the role seperate. Is there any way to find it using formulas or widgets? Appreciate your help
-
Hidden Phases - functionality
My company is trying to log "client travel time" (aka not consulting time) for projects as a separate phase for any given client project. That said, travel time wouldn't be logged too often and we have a preference to not have is show up automatically on staff's timesheets. I'd rather allocate the bank of hours to any…