Hello - we are having problems adjusting a formula to include additional details. The formula is being used on a sheet for a project checklist. The parent formula shows the overall status of child tas…
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…
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 …
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 s…
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 thi…
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 wi…
There should be a way to toggle option if we want to include child rows inside of a filter. Where we can currently have the parent row option, we should be able to also include child rows.
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…
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@ro…
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 attribu…
