-
Formula
Hello All, I am trying to write a formula on a Status column. the conditions are: Not Started if planned start date is in the future and actual start date is blank. In Progress if actual start date is not blank and its not pasted planned start date Delayed if actual start date is blank and today's date is passed planned…
-
Has Children Function
Hi, I am trying to create a formula that will output the average of the child rows IF and ONLY if a line has child rows. If a line doesn't have child rows, I would like it to output (for example) the number "0" if the status column, Status@row, is "To Do" and "100" if Status@row is "Complete". Please let me know if there…
-
Roll up Fail
I have a test scenario as a parent and a sub-task as a child. So let's say, I have 11 sub tasks under the parent, if one of those 11 children has fail in its status, the parent will say fail. If all say pass, then the parent will say pass. I couldn't get the formula to work what I wanted it to do.
-
Add copied row as a child row
I have a row being copied via "Manage References" using INDEX MATCH from Sheet 1 to Sheet 2. If this row matches the project number and has a ".0" indicating added task to the same project, I want this row to be copied over as a child to the Parent row in Sheet 2. Currently it just lists it as a new row. Below is the INDEX…
-
How if a box is checked it any point in the process it will mark it checked for that section
I have sheet that has many items on one that all have a similar process. If one is marked sold at any point (any child step) it will check all the sold for that particualr parent and children. This will stop the notification for that particular item. I do not want it to check the boxes for the whole column because it will…
-
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…
-
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…
-
Is it possible to add child rows to multiple parent rows with a single API call?
I am attempting automate adding standard sub/child tasks to many parent tasks at the same time. Following the API documentation Specify-Row-Location I am using the parentID + toBottom location attributes for every child row. I am consistently getting errorCode 1123 when the program moves from the first parent row to the…
-
Move child row under new parent row when a cell value is changed.
I have parent rows (upcoming week, current week, and past weeks) and I'd like to be able to change the status cell from upcoming week to current week, and have it move the row under a different parent row. Is this possible?
-
Generate child rows from form and link to a specific Parent
I am creating a Grid for not. It will be used as a form for the data entry aspect. And the primary viewing choice would be calendar. Now given that, I initially started with a template, and then just discovered, I don't like the way it works. Below is the template I pulled. The last 2 records are what I entered via the…