Is there a simple way to duplicate a parent row and all Child rows?
Hi @Megan Chapman
You can use the copy/paste function to copy rows and duplicate the hierarchy. You'll need to ensure that the rows are expanded so that you capture all the child rows:
Then when you Paste this into a new, empty row it will maintain the hierarchy of the copied information. See: Copy and Paste Cells, Rows, Formulas, Hierarchy, and Hyperlinks. This article has some other tips and tricks for copying hierarchies
Is this what you were looking to do?
I feel like maybe the question was really Is there a way to copy the parent and all child rows without expanding them?
So, is there? I don't think so, but I'm hoping I'm wrong.
Hi @Suzanne Raphael
If you use the "Copy Row" option from the dropdown menu for the Parent row, it will copy over all the children as well:
See: Copy rows from one sheet to another
@Genevieve P. Copy from the drop down does not copy the children for me. Copy to Another sheet might but I'd like to be able to duplicate a large number of steps multiple times and it seems like you can only do that if you expand all rows.
Thanks for clarifying that you're looking to copy within the same sheet! In this case, you're correct - you will need to select the specific rows you want to copy, Parent and/or Child rows, which means you may need to expand them first.
Thanks @Genevieve P. . Sadly, that's really painful with a 1500 line project plan and the inability to expand/collapse just a section.
Agreed, painful. It is bewildering to me that after all this time—I've been a faithful Smartsheet user for going on a decade now—some just really basic user-oriented stuff like this has just been ignored. Laurels/resting...the surest way for software to die.
Looking to connect a dynamic view of HR dataset to a Power BI dashboard pulling information from multiple other sources. Appreciate any guidance, thanks
Hello! I copied a form I had made for a similar event I am working on now. I made minor adjustments to the form to match the needs of the event. I distributed the form for people to complete, so the form is active, but the data is not populating onto my Smartsheet. Please advise. I would prefer not to have people redo the…
Hello, when I modify a start date on a task I lose the predecessor links. Is there a method to modify task start dates without losing the links? THANKS.
Help shape the future of Smartsheet.
Share your ideas and feature requests.
©2023. All Rights Reserved Smartsheet Inc.