Copy Row Automation excluding child rows

Denise Heffron

I have set up an automation in my project plans to copy rows that are flagged as either a milestone or key activity to another sheet on a weekly basis. The automation is working, however, where the milestone or key activity is a parent task it is copying over all child tasks even when they are not a milestone or key activity. Is there a way to only copy over the line items that are milestones or key activities without any child rows?

Andrée Starå

Hi @Denise Heffron on

Unfortunately, it's not possible at the moment, but it's an excellent idea!

Please submit an Enhancement Request when you have a moment

I hope that helps!

Be safe and have a fantastic weekend!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!

Andrée Starå

Hi @Denise Heffron on

Unfortunately, it's not possible at the moment, but it's an excellent idea!

Please submit an Enhancement Request when you have a moment

I hope that helps!

Be safe and have a fantastic weekend!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!

Julie@WD

@Denise Heffron I was able to get around this:

1. Add a helper formula column showing the parent for each row (=parent([primary column]@row)).
2. Create a set of rows at the top of your sheet that have no children. Indent them under a roll-up row to simplify the view (I labeled mine "Administration - DO NOT EDIT"). Make sure you create enough rows to accommodate the rows you potentially want copied from your sheet (I basically doubled my sheet's row count just to be safe).
3. Use Index to pull the rows you care about into this "administration" section
4. Set your automation to copy only rows with "Administration - DO NOT EDIT" in the parent helper column, along with the other criteria you want.

It works like a charm! I hope this makes sense.