Nesting Parent(Parent())? Is that a thing?

Sinema

I had a super long post but I'm finding that the people who tend to respond are people who want to be hired as consultants.

I'm not really interested in that, so I figured out my own issues the best way I could.

I've got myself to this point

=SUMIFS({Resources_Required Data}, {Group_Name}, {Group 3}, {Weather Data}, PARENT([Primary Column]229), {Day of Week Data}, $[Primary Column]229, {ADD_TIMESTAMP Data}, YEAR(@cell) = 2016)

 

This accomplishing my goal.. even if it could be done better, but the cherry on this formula would be if I could get rid of {Group 3} and have it identify the parent of the parent of that cell..

I use PARENT of a specific location and it updates automatically in the formula, which is great but if that specific piece could identify the parent of the child of that cell then it would be perfect. 

SYSPK

I run into this issue too. What I do is make a helper column on the sheet with the hierarchies, so that only the parent rows that I want get checked off or show the numbers I want to include in my formulas, and I reference only those in the formulas.

Do you need help with pulling data to get only the "grandparent," and not any other rows?

Sinema

@SYSPK

I'm not sure what you mean.

Right now my formula works great, I just need to find a way where I can paste this formula into a cell without tweaking it.  

I just need to be able to grab the value in the "Grandparent" field. 

Paul Newcome

Are you able to post some screenshots?