-
Unique ID auto generated from State designation
I have attached an image of a project schedule. I need to generate a formula for the "task-id" column that auto-generates a unique prefix and suffix based on the "state" column. The formula should reference the two character state and and start at 0001, if this initial encounter of that state. If the state has been…
-
Latest Comment column disconnected, still not able to create new or recreate
I followed the process in the post "Can't select Latest Comment in the edit column properties", disconnected the Latest Comment, Saved/Refreshed, renamed original Latest Comment column, refreshed again, then Inserted Latest Comment (via comment ellipses). It created the Latest Column column but it's not marking it as…
-
Formula error when trying to collect the next task due end date.
I am currently using the formula: =INDEX(COLLECT(Task:Task, Level:Level, 2, Status:Status, <>"Complete", Summary:Summary, 0), 1) to collect the next task due that is not completed for my summary section. I now want to collect the due date for that task. I have a column for "End Date" but not matter what formula I do, I…
-
How can I visually show Phase dates on a calendar rather than just total dates like Gantt
We have several important phases for each project (i.e., Plan phase begin, plan phase end, test phase begin, test phase end, etc.). The Calendar app only lets you show the overall project dates in Gantt, and then we can shade. How would you suggest automating pulling the phases into child lines with just the phase dates -…
-
Predecessor doesn't always update Start Date for some rows.
Hi all, I'm hoping to get some community help/direction with this please. I've been using the same PMO project plan template for over a year now. Recently, I find when I modify the predecessor (+ or - days), the Start Date doesn't change. This doesn't happen for all rows but is consistent with the rows where it happens.…
-
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…
-
Rollup a row from any of our projects to a Unified Sheet
I would like to add a helper column to our projects and if that column has a checkmark in the column - copy the entire row to another created- central project sheet so that I can view it as a Calendar View of major tasks. So each respective PM can select a row that is worthy of rolling up to show this in the Unified…
-
Status Rollup to Parent Formula
Hi, I have this formula that works when automating parent/child tasks in a project plan. =IF(COUNT(CHILDREN(formula@row)) > 0, IF(COUNTIF(CHILDREN(formula@row), "Complete") = COUNT(CHILDREN(formula@row)), "Complete", IF(COUNTIF(CHILDREN(formula@row), "Not Started") = COUNT(CHILDREN(formula@row)), "Not Started", "In…
-
Target Date/Delta info vs Baseline in PMO plan template
Hello! I've read through several past posts related to this but couldn't quite find my answer. We are using the PMO plan template and have activated the baseline feature. My manager has asked if there is a reason to keep the Target Start/End date columns as well as the related Delta columns since they're basically the same…
-
Merged: "Include Parent Rows" option available in Reports --- Similar to Sheet Filters
This discussion has been merged.