How to copy a parent row without all sub-tasks (children) to a roll-up sheet?
I have some projects and would like to create a summary sheet, so all my projects would be listed with the head data in a roll-up sheet.
To do this I used the automation to copy the head row (1th row) to this roll-up sheet.
But the issue that happened then is, that the whole project with all the rows gets copied to the roll-up sheet because the first row of each of my projects is a parent row with plenty of lines (children) beneath.
Does anybody have an idea how I can solve this issue?
Thanks to everybody who is contributing an idea to a solution!
Hans ... from Germany
Picture 1 through 3 shows the the three projects ...
This here shows the automation / work flow
This here shows the Roll-up sheet.
I would just like to have the head row (but not the children beneath here).