Formula Working Everywhere but One Section

Dakota Haeffner

I have a sheet where my formula:

=IFERROR(INDEX(COLLECT(ANCESTORS([Task Name]@row), ANCESTORS(Hierarchy@row), 1), 1), "")

..is working in every section but one and I can't seem to figure out why. It is returning the IFERROR value and when I remove the IFERROR section I get the error #INVALID VALUE. Any ideas?

It should be returning 9.0 Content Management the the fields circled in Red.

The fields circled in green are using the same formula and returning the correct information.

Thanks!

Paul Newcome

Because the data in the hierarchy column is different. There are no ancestors that have a "1", so there is nothing to pull.

Paul Newcome

Because the data in the hierarchy column is different. There are no ancestors that have a "1", so there is nothing to pull.

Dakota Haeffner

Well I feel silly... Thank you @Paul Newcome I think I've been staring at Grids for too long today haha 😵

Paul Newcome

Happy to help. 👍️