Referencing Other Rows Using Absolute References?
I have a sheet where I know what I'm trying to do, but not sure how to go about doing it (or if it's indeed possible).
The sheet in question (funnel) has new entries added via automation once another sheet (requests) is filled out. For each line entry in the funnel, there will always be at least one value in the Developer column.
Recently, we've introduced parent/child rows to help keep more complex projects tracked. An example would be rows 8 - 10 or 11-13 in the screenshot below.
I also have reports that allow users to see just their assigned work as opposed to looking at the larger sheet, but I am getting requests to include in their report, the other child entries for their projects (so they know who to work with).
My question is: Is there a formula I could use as a column formula to display the Developer name of the row below any given cell if it has a keyword (say, "OLT Build") in the Project Name cell?
Again, using the screenshot as an example, I would ideally like the column "proposed new column" to show 'Angela' on row 9, because she's currently listed as the developer in row 10. Likewise, David should show on row 12, since he's the developer on row 13. However, not every row would need this - it should only apply to child rows (and my workaround for this would be if we could include an IF statement where the Project Name contains "OLT Build" for example. I've included arrows here to show which cells would need to be displayed in the new column.
I apologize for the horrendously long explanation. I hope you can make some sense of this, because I can't!
Help Article Resources
Check out the Formula Handbook template!