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), "") 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.


Best Answer