I would like the ability to automatically update values in Resource Management custom fields from values in a Smartsheet sheet either a column or in a Summary field.
Examples of how this could be used:.
In smartsheet I have a portfolio Priority calculation sheet. I would like the priority calculated in the priority column to feed through to a "priority" Project Custom Field.
In my portfolio sheet I have categories allocated to project depending on their type. I would like this fed through to a Custom Field, so I can filter in Resource Manager, but also allow reporting against different categories.
I see this working in a similar way to how "Phase" has been implemented