Forum Discussion
Polestar2021
Mar 22, 2022Copper Contributor
Number of assigned resources on tasks
Someone know how to set up a new column to show me the number of assigned resources on tasks? In column Tekst 1 i have drawn numbers in red just for an example. And also i would like to have a colu...
- Mar 24, 2022Polestar2021,
You're welcome and thanks for the feedback.
What exactly do you mean by, "place out resources"? And I'm confused about you desire to show a list of resources not assigned to a task yet. At the top of the Resource Usage view you can see a list of unassigned resources but, those resources may or may not be appropriate for assignment to any given task.
With respect to removing decimals in the days column, if you simply want a whole number of days then replace the t.Text1 line with this:
t.Text1 = Format(t.Duration / 60 / ActiveProject.HoursPerDay, "##") & " days"
John
Vinod_Singh
Mar 25, 2022Copper Contributor
It's very simple just use count formula in resource sheet view under any number field.
John-project
Mar 25, 2022Silver Contributor
Vinod_Singh,
But that's not what the user asked for. The user asked for a count of resources assigned to each task.
The custom field formula you propose will work for converting the Duration units into days, but since VBA is required for the first item (i.e. task resource assignment count), it's easier to roll the conversion into the macro then to have a separate custom field.
John
But that's not what the user asked for. The user asked for a count of resources assigned to each task.
The custom field formula you propose will work for converting the Duration units into days, but since VBA is required for the first item (i.e. task resource assignment count), it's easier to roll the conversion into the macro then to have a separate custom field.
John
- Vinod_SinghMar 25, 2022Copper Contributor
MS Project is very sufficient tool to manage the project efficiently. No Macro needed.
I used task usage view instead of resource usage and get this. you can slice and dice the way you want to see it.
In the view "TASK: usage", Group the table after Assignment and then Name (resource-name) + check the box "group aggregation, not tasks"
- John-projectMar 26, 2022Silver ContributorVinod_Singh,
Did you read the original post? I don't think you did. The user is showing the Gantt Chart view and is asking for two custom fields in that view. If you've got a way to do that without VBA, I'm listening.
John- Vinod_SinghMar 26, 2022Copper ContributorYes I did read John.
There are many different ways to get your job done. He is looking for number of resource count to a task. I not only gave the count but it shows those name of resource count to a given task. You can hide the names and see only counting at summary. There are various views and filters and formulas and settings in MSP.
I have even put a complete risk register that each task you can associate a risk to it and expected delays due to that risk which can give you a original baselined Gantt view and a risk adjusted plan with possible delays.
You can add RAG signals to each tasks that will tell you whether a task is late .
You can filter late tasks, critical tasks etc.
No macro all there just need to be little patient and applying creative thoughts.