Adding all task participants to parent cell

Ben Donahue
Ben Donahue ✭✭✭✭✭
edited 12/09/19 in Formulas and Functions


I need to add all participants of tasks to the tasks' parent cell (one time each, in case that's an issue). If there is a way to automate this, I would love to hear it.

That's the long and short of it.



Why do I want to do this? Well, in an attempt to add parent rows to reports, but only if they have children appearing in the report, I have am doing these things:

Add an "Include Parent?" checkbox column

Add criteria in the formula for the cells in this column: =IF(OR([% Complete]@row < 1, [% Complete]@row = ""), 1, 0)

This formula mimics a criterion in my report.

As the report will only show tasks assigned to the viewer, I need every assignee in the parent's tasks to appear in the parent "Assigned to" cell in order for every viewer to have pertinent context for the tasks they are being asked to update.

This cannot be the best solution, but the other solutions I have read don't seem to take into account whether or not the child is being included in the report.

SS says they have been working on this since before April of 2016, so maybe the solution is already integrated?

Thank you.


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!