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


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!