-
How to pull the top parent to the row
I need a way to consistently pull the top-level parent to all rows below for our reports. Here's an example: In this case, all of the apples need to have "Alpha" on their row. Similarly, all of the variations of Ed, Edd, and Eddie, as well as Easy and Edison, need to have "Echo" on their row. So on and so forth. Right now,…
-
Parent and Child Rows in filtering
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.
-
How to calculate parent-level values in multiple columns (not just % Completed)?
Hi, In my project sheet, only the % Completed column rolls up automatically using parent/child logic. That works fine. But I want to do something similar in other columns, like: Variance from Baseline (%) Weighted Variance Planned Progress (%) These are all calculated row by row, but I want to show an accurate value at the…
-
Formula or Automation to Indent Rows from Intake Form?
Is it possible to set up a formula or automation with helper columns in a sheet so that if a box is checked (or some other designation that could be done from an intake form…) it can indicate that a task is a sub-process of a larger task and be indented to indicate that relationship? Trying to find a way around manually…
-
Parents and children integrity
Hi I have a single sheet that has parents and children. What I was hoping to do is use Dynamic View to allow various people to add rows. I was hoping that it would automatically add/ categorize the rows into the relevant parent group. However when testing this it adds it to the bottom of the sheet. Is there a formula that…
-
Formula help within a Sheet
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 tasks - if they are all "Completed" then the formula should say "Completed", if they all say "Not Started" then the formula…
-
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.
-
Show what's next on primary row
Primary row 1 Status Up next:subtask 2 Subtask 1 Complete Subtak 2 Subtask 3 Primary row 2 Up Next: Subtask 1 Subtask 1 Subtak 2 Subtask 3 Primary row 3 Up Next: Subtask 3 Subtask 1 Complete Subtak 2 Complete Subtask 3 Is it possible to have a layout like this. So once everything is collapsed it will show what is up next…
-
Help with the following parent/child formula
=COUNTIFS(CHILDREN([Not Applicable]@row), 0, PARENT([Name of the Operational Provision or Rule],"Payer-Accounts") #INCORRECT ARGUMENT SET I am trying to count child rows where a checkbox is set (not applicable) where the parent row title is "Payer-Accounts". I am creating individual Summary values for each of the parent…
-
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…
