Help with IFERROR/INDEX Formula
Hello,
I am trying to write a formula to match a listing of contacts in three separate sheets with associated tasks they are assigned:
=IFERROR(INDEX({SME}, MATCH(Category@row, {SME Listing Range 3}, 0)), IFERROR(INDEX({SMEs for PV QDs involving Clinical}), MATCH(Category@row, CHILDREN({Categories for SME Listing for PV QDs}), 0)), INDEX({Categories for Clinical QDs involving PV Activity}), MATCH(Category@row, ({Clinical QDs involving PV SMEs}), 0))))
One of the sheets has children, so I included that in the formula. I'm getting UNPARSEABLE.
Any insights?
Answers
-
Hello @Nathan Umbriac,
Even if you are referencing a Sheet with hierarchy you don't need to reference CHILDREN(). If you are trying to search only Child rows that's a different story but would require a different strategy, something like INDEX(COLLECT()) would work better with the addition of a column that exists to categorize rows as children or not (rather than sticking in the CHILDREN() function within a lookup formula).
School of Sheets (Smartsheet Partner)
If my answer helped please accept and react w/💡Insightful, ⬆️ Vote Up, ❤️Awesome!
-
Thank you, @Dan Palenchar.
I am only trying to search for child rows in one of the sheets.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.4K Get Help
- 394 Global Discussions
- 213 Industry Talk
- 449 Announcements
- 4.6K Ideas & Feature Requests
- 141 Brandfolder
- 132 Just for fun
- 131 Community Job Board
- 453 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 293 Events
- 35 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!