Reference EACH child from the Parent on Another sheet
I want to display (from another sheet) the child rows. How can I use a formula, on each of my child lines that displays child1, child2, child3, child4, and child5 in my Release Name & Release column. I only require the ability to do this in these 2 columns. The black text is raw data (and the blue text are formulas).
Sherry Fox
Business Process Analyst 3 | C5ISR Group
HII | Mission Technologies
EAP | Mobilizer | Automagician | Superstar | Community Champion
Original Smartsheet Profile: @Sherry Fox
Answers
-
Hey @Sherry Fox
Can I assume that the image above is your Source sheet?
If so, you could use an INDEX(COLLECT formula, referencing the "Release" column as the unique identifier, to bring back row data. It would look something like this:
=INDEX(COLLECT({Release Name Column}, {Release Column}, 202250), 1)
That would bring back the first match, or in this case your parent row. To get the first Child row, you'd swap out the 1 at the end to be 2:
=INDEX(COLLECT({Release Name Column}, {Release Column}, 202250), 2)
And so on:
=INDEX(COLLECT({Release Name Column}, {Release Column}, 202250), 3)
What you could do is have your destination sheet set up so that the Release number and the Child numbers are in two columns, then you can reference these instead of typing them into the formula:
=INDEX(COLLECT({Release Name Column}, {Release Column}, [Release Number]@row), [Child Number]@row)
Let me know if that makes sense!
Cheers,
Genevieve
Need more help? 👀 | Help and Learning Center
こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao! 👋 | Global Discussions
-
Now that makes perfect sense @Genevieve P. ! Thanks so much for taking the extra time to explain the formula based on my screenshot. That really helps so much. I just could not get it before! LOL
Sherry Fox
Business Process Analyst 3 | C5ISR Group
HII | Mission Technologies
EAP | Mobilizer | Automagician | Superstar | Community Champion
Original Smartsheet Profile: @Sherry Fox
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.8K Get Help
- 434 Global Discussions
- 138 Industry Talk
- 470 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 65 Community Job Board
- 486 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!