Formula to List all Sub-Task Owners in One Cell


I am hoping to have a column/cell that indicates all team members that contribute to a given project (ideally in a contact list column type). Is there a formula that could reference only the child rows and compile certain child row cell values into a comprehensive list?

For example: For Project A (shown below), Bob is the project owner and there are other team members who own individual tasks. Is there a formula that I could put in the "Contributors" cell on the project row (Row 1) that would automatically list the values in the "Task Owner" cells of all child rows?


Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!