Formula to List all Sub-Task Owners in One Cell

Options

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?


Tags:

Best Answer

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!