Questions tagged [ms-project]
Use this generic tag for questions that apply to most versions of Microsoft Project. For version-specific questions, please use an alternate tag instead of the catch-all tag. Version tags currently include: ms-project-2003, ms-project-2007, ms-project-2010, ms-project-2013, and ms-project-2016.
0
votes
1answer
10 views
Microsoft Project - how to calculate start dates based on a set time from the finish date?
I have multiple tasks that have different durations that I want to start at different times from a go live date, i.e. finish date for an entire project.
For example: Project must finish on 01 Dec ...
1
vote
1answer
30 views
Why does MS Project allow for a 2 day duration task with 8 hours of work and a resource at 100% units?
I have a fixed-duration task in MS Project that is 2 days in duration and 8 hours of work. When I assign a resource to the task, the resource units are automatically set to 50%. If I change the ...
0
votes
0answers
15 views
How come when I end my sprint, the sprint of the other team in the same project ends as well? How can I separate them? [on hold]
I am working in a company, where there is a legacy left in Jira, but the previous owners ot the projects are no longer in the company.
So the workflow for certain issue types was changed, and after ...
0
votes
1answer
14 views
Microsoft Project 2019 - problem allocating resources to tasks outside their calendar working hours
We have a standard calendar work week. (Monday to Friday with weekends off)
Our resources have "standard" calendar - so scheduling as standard for them is a normal work week.
However, we have ...
3
votes
0answers
42 views
Prevent hourly tasks spanning days
Is there a simple way to block tasks from spanning days? I have some tasks such as interviews & exams which are 2 or 4 hours long but they obviously cannot span days.
However MS project is ...
2
votes
1answer
30 views
MS Project resource graph across multiple projects
I am using MS Project to create Gantt charts for multiple projects. Each project consists of different resources but these resources are shared across all of these projects.
Currently these resources ...
1
vote
1answer
40 views
How to plan for variable workload for a given task and resource?
I have to plan a project in which for a given task and given resource, workload changes from one month to another. How I can plan this in MS project? It is very critical for me to monitor resource ...
0
votes
2answers
59 views
Multiple predecessors
I have predecessor 46 and 147 on task 200.
Task 147 finish date is after task 46, but task 200 is starting the day after task 46, not after task 147 as expected. How do I fix this?
I would ...
2
votes
1answer
35 views
Rotating-schedule calendar
I'm new both to MS Project and this kind of forum. I've searched for this question and I haven't found it, so sorry if it has been already asked.
I'm trying to make new resources calendars, but they ...
2
votes
1answer
56 views
How to divide a generic resource?
I am still new at using ms project Professional. My project has already assigned resources.
For instance, let's take developers who together have a maximum effort of 200%, which means I have 2 ...
1
vote
4answers
122 views
Should activities before kick-off meeting be represented in a Schedule Plan
I wonder if activities like contract and agreement reviews, meetings to discuss preliminary information, SOW review, and contract approved (as deliverable and milestone) should be included in a gantt ...
0
votes
1answer
31 views
ms project - delay a task due to unaviability of 1 resource
I want to schedule tasks using multiple resources. The work task is fixed and multiple resources are allocated to the tasks.
I want to auto-schedule the tasks, however, when 1 resource is ...
-1
votes
1answer
54 views
How to effectively implement Scrum for a small project (max duration 6 months) with defined project deadlines?
In my current company, they are using Waterfall methodology in defining the gateways for new project approval and developing detailed timeline with completion date (gantt chart) based on the ...
1
vote
1answer
17 views
Add Landmarks lag or date based on project start date
My project have some tasks (landmarks) that occurs at every X month, like:
- Project technical report (PTR) at each 4 months
How should I define the landmarks date relative to project start?
...
3
votes
1answer
24 views
How to add new task below the currently selected task
When adding steps/tasks to a project plan, I often do this sequentially in the order they need to be done.
However, pressing "Insert" adds the new task above the current task. How can I add new ...
2
votes
1answer
68 views
Assign Resources Automatically in the Most Efficient Manner
Firstly I have to state that I am not a project manager. I am a software development team leader that has been tasked with giving a plan for a large project for my team. We work in a Scrum-like ...
1
vote
0answers
224 views
Project Online - Enterprise Custom Field Not Calculating Formula Correctly?
I am new to MS Project (~1 week experience) and could use some help with an Enterprise Custom Field I'm trying to create. I'm using Project through Project Web App in Office 365 (I assume this is ...
3
votes
1answer
33 views
Create MS Project report which to return incomplete tasks per user with due date
I want to be able to produce a report I can share with resources on a project so that they have visibility on what outstanding tasks they have (overdue, current, future) and when they are due.
...
0
votes
1answer
67 views
Microsoft Project IIF (immediate if) limitations
I'd like to understand better the restrictions applied to IIF (immediate Ifs) on MS Project 2016, such as:
how many nested iifs are allowed
how many characters are accepted in a formula
how many ...
2
votes
1answer
27 views
MS Project Change Working Time - Roster
How can I change the working time to 2 weeks ( working - 14 days) and 1 week (not working - 7 days)? Is this able to be automatically populated?
2
votes
0answers
35 views
Change task distribution with % completed
I'm using MS Project 2010. When assigning a task with duration say 5 days and work of say 10 hours. Then MSP distributes the occupation for that resource over the whole duration.
e.g.
Mon 2h | Tue ...
2
votes
1answer
36 views
How to share with a link to a viewer with stakeholders
I'm tired of trying to keep everyone partially happy - some prefer excel, some prefer pdf, very few have ms project.
What I'm looking for is a simple link that I could send out to everyone, giving ...
3
votes
1answer
42 views
MS Project - Link multiple columns to the Resource Sheet
I have (somehow) managed to create one column which successfully links to the Resource Sheet. When using the drop down, it brings up all of the names in the resource sheet, and allows you to choose ...
1
vote
0answers
23 views
Add columns in master project from external project tasks
I have created a master project ( in ms project 2010 and published in ms epm 2013)that contains only key milestones tasks from external projects. Hence this master project plan contains high level ...
2
votes
0answers
40 views
Ms project - Avoid task split up in minutes
I am trying to update my ms project plan with the following:
- replan al 0% and partly completed tasks from the new status date.
- Tasks can be split up
- Plan based on priority and available time for ...
4
votes
1answer
62 views
Resource-Task table in MS Project
Does anybody knows how to export workload of single resources (columns) per task (rows) from MS Project? The result should look as follows:
.............Resource 1.....Resource 2.....Resource 3 Task
...
1
vote
1answer
34 views
Autosave: How to prevent it being re-enabled with each new session
I find the Autosave feature to be very intrusive and it also interferes with some macros I run. I know how to disable it via File/Options/Save/untick the box, but even if I then immediately save my ...
0
votes
1answer
143 views
Work days and Duration does not match
I am using a 5 working days & 8 hours standard calendar. My task is 30 days . I have selected a start date on Monday and end date on Friday (30th work day) but the durationn reflects as 40 days ...
0
votes
1answer
24 views
Report in MS Project (Hr/task/resource)
I am trying to find/create a report in MS Project 2013 in order to display hours done in a month by a certain group of resource or a resource only (they are already grouped in the Allocation tab) with ...
3
votes
3answers
48 views
Sharing a file without them being able to edit the main file
I need to either create or share my project with others. I don't want them to be able to make changes to my project though. I've tried creating a new one, but they still are able to make changes to ...
0
votes
1answer
281 views
Tracking Gantt Chart Not Showing All Tasks
I am trying to do an earned value analysis and there are tasks in my normal Gantt chart that when I switch the view to tracking gantt are not visible. Could this have to do with where I set my status ...
1
vote
1answer
59 views
Leveling; getting unexpected results
I have spent hours reading up on the leveling algorithm and trying various alternative approaches but I have a problem I simply can't figure out. I'm using MSP 2016.
My schedule consists of around ...
1
vote
1answer
56 views
MS Project - Summary Task split by leveling
I have a summary task, and have the 'Leveling Can Split' option set to No.
The four subtasks which are in sequence, also have LCS set to No.
In the Leveling options I also have 'Leveling can create ...
2
votes
0answers
34 views
Determine to which task a resource is allocated on a particular day
Using a shared resource pool for several project plans (each plan is contained in a separate file), what is the simplest way of working out to which task a given resource is allocated on a particular ...
0
votes
1answer
225 views
Working and non working days
I want to ask if I need to have non working days and working days in a same day. Can we do that in microsoft project?
For example Saturday (same date) for items Consultant approval I want to set it ...
1
vote
1answer
223 views
EOT and LOT vs EET and LET
Are the Earliest Occurrence time and Latest occurrence time same as the Earliest Event time and Latest event time or are they different? If they are different can you please explain to me what are EOT ...
0
votes
1answer
34 views
MS Project 2016 updating Actual Cost figures for Cost Resources that are set to accrue at the end of the task
I am having an issue where MS Project 2016 is prorating the actual cost figures for cost resources that have been set to accrue at the end of the tasks. I have tried everything I can think about and ...
1
vote
1answer
192 views
Printing specific date range in ms project 2016
I am trying to print a specific date range from a gantt chart view in ms project 2016, but all that prints out is the whole project. Can you help?
0
votes
1answer
36 views
MS Project burndown for outline level
I'm working on creating a burndown graph for a large project that I'm trying to schedule, but I don't want the sub-tasks to be counted as a remaining actual task for the burndowns. Is there a method ...
0
votes
1answer
51 views
MS Project - Multi-year Inflation
I am managing a 3 year project in a country where the average annual inflation rate is 12%. Instead of going through every item and entering "+12%" into the cost rate table for each item, is there a ...
1
vote
1answer
36 views
How to Import Resource Availability from Excel when it varies by month
I have a number of generic resources, eg Engineers, where each individual is treated as interchangeable with all the other Engineers. I want to show their availability as for instance 100% in October ...
0
votes
2answers
63 views
ConsolidateProjects Method: how can I import Sub Project Summary task Custom field contents?
If possible I want to avoid using Resource Pools and embedded project files as I have had problems with these in a Sharepoint environment, so I am exploring using the ConsolidateProjects Method to ...
2
votes
1answer
41 views
How to make identical changes to multiple sub project files
I am about to create a master plan that will contain over 200 small sub project files. Each sub project file will have common elements such as standard Custom fields.
I have created a template for ...
1
vote
2answers
75 views
Auto populate project level Priority field based on lookup to Excel file table
I have multiple small plans (managed by PMs) embedded in a master plan file which I manage. The PMs can add tasks to the sub plans as necessary.
After receiving each sub plan and refreshing the ...
0
votes
1answer
222 views
MS Project 2013: Summary task not showing duration correctly
I am working on MS Project 2013. The summary task No. 6 is not showing the duration correctly. Refer to the picture below.
Please help.
3
votes
3answers
128 views
Need help- Documentation for non-technical people using Agile
Now we are using Agile and hardly create BRD\FRD, we create user stories, and all this is good for everyone working in the same department. Including the stakeholders. However, if I would like to ...
0
votes
1answer
89 views
Why does the graphic indicator not show for milestone task?
Why for milestone task, the graphic indicator did not show?
The formula to consider is the following:
IIf(CDbl([Baseline Finish]>60000)," Not Baseline",IIf(([Baseline Duration]=0 Or [Duration]=0),...
0
votes
1answer
33 views
MSProject show main resource on Summary tasks
How can I show the main (resource with maximum hours) for Summary tasks.
I suspect I would need to set a custom text field to show this, but how would I structure this?
thanks
0
votes
1answer
42 views
Change manually to auto schedule
I want to change the start date of a specific section in my project.
When I do that, it automatically changes the mode of this section from auto to manually schedule.
Is it possible to change the ...
1
vote
0answers
52 views
MS-Project 2016: Sort does not work
With MS-Project 2016 (version up-to-date) I have created a custom report (showing filtered tasks). I want to sort it ascending by Finish date (soonest finish on the top). But it does not work.
It ...
