-
How can I exclude "child rows" when executing VLOOKUP?
I am currently trying to update the VLOOKUP formula to exclude child rows. I setup a reference sheet to run the formula, but the only way for it to run properly is to add the child rows. If any child row value is changed, it shows as #NO MATCH, however, I would just like to appear blank. I am currently running the current…
-
Formula for Counting Parent Rows based on a specific column criteria
I need a Countif formula to count the number parent rows that have a specific column value of > 37 , and another formula to count the number of parent rows with the same specific columns value of ,+ 37. Can this be done in the Sheet Summary? The issue is I have Children rows beneath a few Parent rows and I don't want those…
-
How would I edit this formula to only COUNTIFS in a PARENT row?
How would I edit this formula to only COUNTIFS in a PARENT row? I'm not looking to add a helper column. Thanks in advance! =COUNTIFS({THD Team Locked In}, "1", {Billing Month}, Month@row, {APM}, "Emily")
-
Starting with a Sheet, that Now needs to be a Gantt - how does one get roll-up summary info
We started with what we thought was going to be a simple sheet that has grown and now had Target Start and Target End date columns. Now we look at is as a Gantt (again not started as a Gantt sheet) So we made parent and child rows, have the settings in Gantt view looking at these date columns. However, if you indent/make a…
-
Parent Row Schedule Health functionality
Hello, I have a column formula that is returning random results, mostly on parent rows. The formula is: =IF(Status@row = "Complete", "Green", IF(OR(Status@row = "In Progress", Status@row = "Not Started", Status@row = "On Hold"), IF(ISBLANK([Target End Date]@row), "Red", IF([Target End Date]@row < TODAY(), "Red", IF([Target…
-
Countifs only if its a parent row
Hi guys, running into a dilemma where im trying create a countifs for a dashboard for statuses, but I only want the main status from the parent columns and not the tasks. Screenshot shows the status field has multiple in the status "Draft". I'm not super familiar with the children/parent fomula and could use a little help!…
-
Include Hyperlink in Formula where I'm pulling through the parent task?
Hello! Im my sheet I have a formula in a helper column to pull the value of the parent task into each row - our parent task is our project deliverable name and it helps to have that in line for other views / reports. In our parent tasks, we are hyperlinking to our project brief. However, that hyperlink does not pull…
-
The smallest date with a specific status in the child cell
Hello community, I hope this message finds you well. I need a formula to classify as TRUE if my row has a "Not Started" status and presents the smallest start date within the cells, which in the example figure, are filled in white. However, I couldn't come up with an efficient result. Any tips or help to build this formula…
-
Copying Parent Row into same sheet column of Child Row
Hi, Is there anyway that we can copy parent row into the child row and apply to the whole same column without changing the parent row information? For example: =Parent({Test]@row) works if I put into the child rows only, but when I convert to same column formula the information in the parent row disappears so the…
-
Easy way to copy a nested row into the same sheet
Hello, I'm trying to create a workflow for one of our users to check off when making a new hire, and then when it's done, it'll get moved to an archive. The issue I'm running into is that I can't easily make a template for the users to copy when utilizing the sheet. I want users to be able to stay in this one sheet to…
