Referencing a cell on another sheet based on information in its' parent

Nik Schmidt

Hi everybody, been melting my brain trying to get this one

I have a bunch of project sheets set up to send their rows back to a central tracking sheet. I have a Master Status sheet that parses that tracking sheet for each project. It looks up a unique project ID, parses that central tracking sheet for the latest row with that ID, and returns values from that row. (such as overall project % complete).

But what if I want a value from the children of this project? I tried using Children() but am given an error that this function is not allowed to reference other sheets.

My children rows dont have information that uniquely identifies the project, because they come from sheets that only refer to one project. Can I not somehow say to my central tracking sheet "locate most recent row with Project ID ____, and return child with name _____"?

SoS | Dan Palenchar

I'd recommend adding a helper column that returns the Child value for that row and then reference this column in your cross sheet formula.