-
Best Way to Link Dates between sheets?
We want to pull high-level dates from a project plan to add details on another sheet so it's easier to discuss. For example, we may have 'Topic Meetings' as a single line-item on the overall Project Plan, but on a meetings sheet we would have 'HR', 'Finance', 'Tech', etc. We turned off dependencies on the meetings sheet…
-
PICK CHART to determine Project viability
Hello, We are starting to use Pick charts to determine project feasibility and impact so that we only work on the most important things. It would be really great if a template set was set up with a project plan template like Template Set - Project Management Office where the template set would have a project submission…
-
Project Settings Options Not Providing Every Column as Option for % Complete Column
We have a Project Plan with dependencies anables and parent/child relationships across the plan. I want to show the % complete visually in the Gantt section where the thinner % complete ribbon overlays the task ribbon based on it's percent complete. However, when I go into Project Settings>Options>% Complete column, it…
-
Formula Help
I am looking to set up a formula where a status column gets automatically updated to a certain color based on the relationship of the % complete column and the end date column for each row in the plan. Examples of what I am looking for below. If % Complete = 100%, then Status Column = Green If % Complete < 100% and Target…
-
RAG Status
Hello! Newbie here :) I was wondering if someone could help with a formula I'm attempting to put together to calculate a RAG symbol status for individual tasks as well as the overall project plan. Individual Tasks: If status is complete = blue If status is in progress OR not started AND end date is today = yellow If status…
-
Project Plan - Start/End Dates, % Complete and Duration columns not updating.
Happy Friday! Appreciate your feedback, please! Here's a pic from my Project plan (created from the PMO Template) showing the column titles and rows 1-6. Rows 3-6 are in the first phase of the project (under row 2, grey). These are the only completed tasks out of 39 for the entire project. the rest are not started. I'm…
-
How to show/convert days to weeks on project plan
Hello All, duration column circled in blue is automated as per the project setting circled in red is all manual I know weeks cant be determined from entering dates so i entered weeks manually in actual duration column and it has set the dates, but the roll up is in days is there a formula I can use on another column to…
-
Best Practices/Work Arounds for the lack of "elapsed" and "months" options
I want to open the discussion in this industry forum because I'm certain this would be a group of folks that regularly encounter this short coming. The inability to put "edays" in the predecessors column leads me to a ton of extra rows that serve no purpose other than being a way to get "# edays" in the duration column so…
-
Provisioned Project Plan Changing to Gantt View from Grid View
We have a project plan that we spin up using the multi-tier functionality in Control Center (the plan is our child project) and each time it is provisioned the default view is Gantt. BUT in the template it is in Grid view (which is what we prefer). How can I fix this?
-
Sheet summary to populate date in sheet
Hi all, I'm currently creating a template to monitor store closures and need some support in setting up a way to populate a date from the sheet summary. The end goal is to when in use, to be able to populate the date for the activity to start and able to flag any outstanding points after 30 days. We are able to populate…
