Formula Working Everywhere but One Section
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!
Best Answer
-
Because the data in the hierarchy column is different. There are no ancestors that have a "1", so there is nothing to pull.
Answers
-
Because the data in the hierarchy column is different. There are no ancestors that have a "1", so there is nothing to pull.
-
Well I feel silly... Thank you @Paul Newcome I think I've been staring at Grids for too long today haha π΅
