Resource Management

Start date & End date in resource allocation underlying report from analytics in Resource management
Hi team, As earlier I already posted and shared the idea for large and mid cap organizations to help th data regarding resource allocation start date and end date. As of now if you will generate underlying data from resource management you will get most of the data, project name client, scheduled hours etc but, in Resource…
Resource Management Implementation
Hi everyone, We have recently implemented RM along with Smartsheet Control Center. I think we ignored RM during UAT. And now we are having issues in RM with regards to allocation, capacity & analytics. Will anyone be able to share their implementation strategy with me which may help us. Looking forward to hearing back.…
Resource Management License Needed to Access Slide Out?
Do you have to be a licensed user in Resource Management (RM) to access the RM slide out from a sheet? I understand that you need to be licensed to manage resources and project plans from rm.smartsheet.com, but do you need an RM license to do these same functions but from a sheet instead?
Is it possible to transfer all time logged in Resource Mgmt to a different week?
One of my team members logged all of her time for last week under this week in RM. Is there a way to easily transfer it to last week without having to do it manually? We track time against tasks within projects so there is A LOT to move manually if there is no other way to do this.
Track time in Resource Management by task, not by project overall
Is this possible? Am I missing something obvious? It seems in Resource Management we can only track time to the project and not to individual tasks within the project. I'm trying to solve an issue for a team within our org and they actually came to us after finding a preview of the Time & Expenses feature in RM, which…
Is it possible to pull data from rm.smartsheet.com to smartsheet.com automatically?
Hi, We're trying to automate reporting, to prevent having to manually download data from rm.smartsheet.com and edit in different programmes e.g. googlesheets. Is it possible to automatically pull data from rm.smartsheet.com into smartsheet.com, which then feeds into a project dashboard in smartsheet.com? The only benefits…
Help with TIME() Formula
Hello, I am testing out the TIME() function and working on a formula to determine the amount of hours and minutes elapsed between a Start and Finish columns. I thought I had it figured out, however, I noticed that for my row that has a Start time of 3 pm and a Finish time of 5 pm, it was showing a time difference of "1…
SUM Rows in Column A that meet multiple criteria including distinct values in Column B
I am trying to use a formula to: Referencing other sheet(s)… Sum story points by PE (Person) if: The Parent PCR (Identifier) is Unique The PCR Status is one of 5 options The PE assigned is an exact match (ie "Derrick Franklin") Here are a few that I feel are close, but not giving me the exact number's I'm looking for: This…
Please Help
I am trying to use this formula- =IF(CONTACTVALUE({Hardware}) = "Andrew Mattos", [Points Bucket]@row - 10, 0)- Basically I want it to search my TR Project sheet for the Hardware column and if it see's Andrew Mattos contact to subtract 10 points from my point bucket column in my data sheet. It keeps coming back Unparseable.
Allow formulas in Assigned To when Resource Management is enabled
Currently, with dependencies enabled the Start, Finish, Duration fields do not accept formulas. Additionally with RM enabled (including the new Resource Heatmap), Assigned To can no longer be formula driven. Use case: when our Marketing team generates a copy of their campaign sheet, they have a number of pre-set tasks that…

Resource Management

Discussion List