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 😵
-
Happy to help. 👍️
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 65.9K Get Help
- 429 Global Discussions
- 147 Industry Talk
- 487 Announcements
- 5.2K Ideas & Feature Requests
- 86 Brandfolder
- 151 Just for fun
- 74 Community Job Board
- 497 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 305 Events
- 36 Webinars
- 7.3K Forum Archives