INDEX multiple CHILDREN values in PARENTrow
Hi,
I would like to index multiple children in a parent row. I'm using this formula if there is 3 children :
="•" + INDEX(CHILDREN([Primary Column]@row), 1) + $[Column3]$1 + INDEX(CHILDREN([Primary Column]@row), 2) + $[Column3]$1 + INDEX(CHILDREN([Primary Column]@row), 3)
I'm using this formula if there is 2 children :
="•" + INDEX(CHILDREN([Primary Column]@row), 1) + $[Column3]$1 + INDEX(CHILDREN([Primary Column]@row), 2)
Is it possible to make sure that the formula count the number of children and return the correct values in the parent row instead of adding up all index?
Thank you
Best Answer
-
=join(children([primary column]@row),char(10)+"•")
That should do it.
Answers
-
=join(children([primary column]@row),char(10)+"•")
That should do it.
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!