Adding all task participants to parent cell

Ben Donahue

WHAT I WANT TO DO:

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 I WANT TO DO THIS:

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.

Andrée Starå

Hi Ben,

I might have an idea.

Can you maybe share the sheet(s) or some screenshots? (Delete/replace any confidential/sensitive information before sharing) That would make it easier to help. (share too, andree@getdone.se)

I hope that helps!

Have a fantastic weekend!

Best,

Andrée Starå

Workflow Consultant / CEO @ WORK BOLD