-
Project Metadata Sheet no updating
Hello I've completed the project intake form which has populated the Project Intake Sheet in the PMO Template set. I've then followed the instructions and copied the Project ID into the Project ID column in the Project Metadata sheet. When I do this, the rest of the data, e.g. Project Name, Project Manager etc is just…
-
Keeping track of old baselines
Hi I want to know if there is a simple way of keeping a log of baselines, e.g. each time it is reset, the old baseline is logged, similar to version control. The idea is that at the end of a project (which underwent change control resulting in the timeline needing to be re-baselined) we will be able to review the changes…
-
Help with Trend Data
I need some help with collecting data for trending. Currently, I have multiple projects with all of their top line data dynamically linked to a Roll-up Sheet. On this roll-up sheet I have data that is calculated from the project Status. Ex: How many projects are Red, Yellow and Green. This works really well for live data.…
-
Column functionality breaks when copying sheet
I have a template that I created to use for several projects within my org. When I create a new sheet from this template my Duration and % complete columns completely break and do not work anymore. I have removed and recreated the columns to see if this will rectify the issue and it does not. No matter what I do I cannot…
-
Merged: parent timelines when dependencies are enabled gantt Bar formatting
This discussion has been merged.
-
Folder (Highlight) Colors within Workspace
I have access to multiple folders within my workspace, like everyone does. I would like the ability to highlight folders. And my highlighting would be exclusive to my account. Others that have access to the same folders would not see my highlighting. The main folder names (mostly created by others), are so similar. I often…
-
Survey- how do you track projects over multiple years?
Hello Community, I am trying to track projects over multiple years, but each project varies in length. My concerns are hitting the max number of columns and not having to do a bunch of manual set up at the end of the year. Has anyone else had this issue? How did you solve it? Thanks, Ashley
-
Duration and Date Dependencies - Reference Cell in Same Sheet
Hi, Very novice user here. I am using Dependencies and am trying to find a way to make the Duration and Start/Complete Dates reference another cell within the same sheet. Screenshot attached. I'm trying to have the information in the Project Summary cells pulled into highlighted durations/dates so that it doesn't have to…
-
I need to calculate % Complete
Hi, I am trying to calculate % complete with an IF formula because if it is marked complete I want it to say 100% and the current formula is tell me it is 3,098% complete because start and end date are in the past. Old formula: =(TODAY() - [Start Date]@row) / ([End Date]@row - [Start Date]@row) What I am trying to write…
