Btw, I followed your suggestion and asked this question in the Microsoft Forum, yet I'm not sure I want to follow up with this issue any more. A couple of days ago, I don't know what went wrong, I realized that the formulas in my custom fields was missing. I suspected that it had occurred during synchronization (saving & publishing) with Project Server.
PMI Online Courses. Enterprise Resource Pool – a single source on Project Server that contains resource. The columns can be re-ordered, added, or hidden just like any other view within Project Professional. In Microsoft Project, a proposed assignment “does not detract from the. Exhibit 7 – Formula Explanation. Apr 3, 2019 - Updating resource custom field values via REST in Microsoft Flow. However at the moment the Project Online connectors are still in “preview”. This article focuses on Enterprise Resource custom fields but applies equally. The remainder of that XML deserves a short explanation, ignoring the XML. I am using MS Project to list all the projects and work my department is doing. I have created custom fields (Text 1(proj name) and Text 2 (proj number)) in my Gantt Chart view for each task and subtask.How can I create a macro to get these to show up in my Resource Usage view with all the data I entered in at the Gantt Chart view?
So I decided not to use formulas for the time being. That's why I'm having second thoughts about doing further customization.–Mar 28 '15 at 15:27. MS Project has the ability to level according to task priority.
Double click on a task to pull up the Task Information dialogue. In the 'General' tab, look for 'Priority.' The default setting is 500. Change this to reflect the relative priority of the task.
It sounds like you'll need to devise a way for priority to encompassboth urgency and complexity. Go to the Resource tab in the ribbon.
Click on 'Leveling Options.' Leveling Options is listed towards the right above 'Clear Leveling' and 'Next Overallocation.' Thisopens the Resource Leveling settings dialogue. In the lower portion of the dialogue there is a 'Resolving Overallactions' section. Set the 'leveling order' to 'priority, standard.'
The default is standard. Priority, standard will level tasks based on priorityfirst, then according to the standard process. I agree that it would be easier to work on a way so that urgency and complexity can be represented using built-in fields such as priority.
However, units (resource assignment fields) should be more appropriate than priority. It will be easier to represent the workload of resources using units rather than using priority. It's just that I wanted to create a more standardize way of measuring workloads because I'm planning to share this with other divisions in my company. That's why I'm avoiding the need to manually enter the value of units.–Mar 28 '15 at 15:36. I finally solved my problem.
Many thanks to @JulieS for pointing me to the Microsoft Project forum. One particular user in that forum is very helpful. Here's the thread that I created to ask this question:Anyway, it turns out that you can't mix task fields, resource fields, and assignment fields in Microsoft Project. At least, not normally. To be able to do that, the only possible way is to use VBA. Here's a run down of the things I'm doing to solve my problem.First of all, I added two new task fields named Urgency and Complexity.
The value of Urgency is set to use lookup tables with 3 values: '1 - Normal', '2 - Medium', '3 - Important'. I also set the value of Complexity to use lookup tables with 3 values: '1 - Low', '2 - Medium', '3 - High'.