-
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 - Set schedule for exporting analytics reports
the exporting analytics reports is currently manually triggered. Having the option to trigger or schedule the export of a report will be a great addition.
-
Import Data Elements into Resource Management
Please allow for import of holidays, Place Holders, Disciplines, Roles, Locations and custom fields into resource management. Basically all fields that do not already have an import/export. It takes too long to key these things. Also if I set holidays and the values in smartsheet this should have synced up upon import.
-
Resource Management - View Only Access
View Only Access for Non-licensed Users for Resources. We would see a lot of value if users who are not licensed could look at RM.
-
Resource Management API - Users
Hi Every one, I am wondering if anyone faced this issue before. I am trying to make an API call using the users API as following. The issue that I don't get tags in the response as mentioned in the API documentation: I get ''tags' in the response only when I pass it as a sting as following: Below is a sample response after…
-
HeatMap & Workload tracking Permissions
Current Unmanaged users can see all assignments for the resources they type into the Assigned To column by then viewing the Workload schedule. This contradicts the security permission available in Resource Management ie Portfolio Editor which provides a level of security for resources only having visibility of projects…
-
Merged: Alert Someone should support Resource Groups
This discussion has been merged.
-
Resource Management and Calendar connection
I have field employees that I need to communicate their daily/weekly schedule.Im currently in the process of setting up RM and have the premium calendar app. I'm assuming that they connect but I could be wrong. Does anyone know if they do connect or do i need to connect each Project sheet to the calendar? any clarity would…
