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

CamSME

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!

Darren Mullen

@CamSME you'll use join and collect with children or decedents as the range. This video might help.

https://youtu.be/Dzo0UYjxMmI

Darren Mullen

@CamSME you'll use join and collect with children or decedents as the range. This video might help.

https://youtu.be/Dzo0UYjxMmI

CamSME

@Darren Mullen it worked perfectly, thank you!!

Darren Mullen

@CamSME great! Thanks for letting me know!