Stumped on a formula for a parent cell to aggregate names of the subtasks.

I'd like to capture the Individual Project names, tracked by subtasks, and aggregate them in the Parent Cell (All Project Names). This way, when minimized, I don't have to expand to see which Sites the task is for. Also for Dashboard views, to see which Sites are part of the parent project that is being tracked.
Screenshot below. I'd like for the yellow cell, to display Sites 1, 2, 4, 6.
Any help is much appreciated!
Best Answer
-
@CamSME you'll use join and collect with children or decedents as the range. This video might help.
Darren Mullen, join the Smartsheet Guru Elite
Get my 7 Smartsheet tips here
Author of: Smartsheet Architecture Solutions
Answers
-
@CamSME you'll use join and collect with children or decedents as the range. This video might help.
Darren Mullen, join the Smartsheet Guru Elite
Get my 7 Smartsheet tips here
Author of: Smartsheet Architecture Solutions
-
@Darren Mullen it worked perfectly, thank you!!
-
@CamSME great! Thanks for letting me know!
Darren Mullen, join the Smartsheet Guru Elite
Get my 7 Smartsheet tips here
Author of: Smartsheet Architecture Solutions
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 66K Get Help
- 429 Global Discussions
- 149 Industry Talk
- 488 Announcements
- 5.2K Ideas & Feature Requests
- 85 Brandfolder
- 153 Just for fun
- 74 Community Job Board
- 499 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 305 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!