-
Retrieve value from "Top Parent" when Ancestor level = 2
I have a project management sheet. CSYYXXXX is the header for the project name column Tasks is the tasks column - at the parent row, I just write "Tasks" and then there are child rows below that. Some of these child rows and another level of descendant rows. I want a column formula (to serve as a helper column for various…
-
Merged: Find and Replace Function in Formulas
This discussion has been merged.
-
Project Status Formula and Checklist items
We have a project checklist template that is provisioned via Control Center. There are hidden columns (the "Task Not Needed" referenced in the formula) that show only the checklist for the Project Type selected in intake - the tasks that are not supposed to appear are checked because all the project-specific checklists…
-
Help with cross cell referencing
I have a sheet of incidents that I want to be able to count the number of certain types in a month. In my incident sheet I have a column called "Type of Incident", that has values of Safety, Environment and Quality A column for the date, that I have used formulas in helper columns to get the Month and year. So now a cell…
-
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…
-
How can I use index match + either another index match or an IF statement to pull Data from multiple
How can I use index match + either another index match or an IF statement to pull Data from multiple sheets? In my case I have 3 sheets: Sheet 1 - Current Project List - consists information that track active projects. (each Project has a unique project code) Sheet 2- Closed Project List - consists of previous years…
-
How can I enter data in a field that has a column formula?
I have a Contact list as a column type on sheet A and it is attached to my feeder sheet B. Sheet A also has a form attached to it and when a list option is selected, the contact list is populated on the sheet. However, if the list option is not selected, then the contact list does not populate. I need to be able to fill in…
-
#Incorrect Argument Set
Hello, I am having issues with a formula and am hoping that someone can help. I am trying to tie two separate columns (Project Percentage and Days Remaining) to automate a project status column. I am getting an incorrect argument set error. Not Started = Project percentage is 0% Complete = Project percentage is 100% On…
-
Merged: New Column Type: Time
This discussion has been merged.
-
Automatic Phase from WorkBreakdown
Hello all! I'm modifying the Simple Portfolio Work Breakdown Schedule and having a little trouble. I like the way the Work Breakdown structure works but I'd really like an automatic way to track which Phase something is in. I know I could just add a column and manually select which Phase tasks and sub tasks are in, but I'm…
