Welcome to the Smartsheet Forum Archives


The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.

Copying multiple indented rows

Erin Edwards
Erin Edwards ✭
edited 12/09/19 in Archived 2015 Posts

Is there a way of copy & pasting in multiple indented rows without having to do individually?

 

Tags:
· Share on FacebookShare on Twitter

Comments

  • Travis
    Travis Employee
    edited 05/23/15

    Erin - you can copy and paste a group of indented rows by single left clicking on the parent row number, hold shift, single left click on the last row number of the group of rows, then press CTRL + C to copy (CMD on a Mac) and CTRL + V to paste (CMD on a Mac).

    · Share on FacebookShare on Twitter
  • J Tech
    J Tech ✭✭✭✭✭
    edited 08/18/15

    When you have a parent row and multiple children rows, and they need to be copied and then pasted onto the same sheet, what is the best way of doing this without having to outdent the one you pasted?

    Regards

    J Tech

    If my response has helped you in any way or provided a solution to your problem, please consider supporting the community by marking it as Insightful, Vote Up, or Awesome. Additionally, you can mark it as the accepted answer, which will make it easier for others to find a solution or get help with a similar issue in the future. Your support is greatly appreciated!
    · Share on FacebookShare on Twitter
  • Travis
    Travis Employee

    To confirm, you want to paste just the values and NOT the hierarchy? Copy the text, right click where you want to paste and select Paste Special > Values 

    · Share on FacebookShare on Twitter
  • Shailendra Singh
    Shailendra Singh ✭
    edited 10/29/15

    I think the original question is about copy Cells with Hierarchy. 

    I have a long list of Cells having Activities & Tasks with multiple hierarchies in a Checklist Sheet which is shared in View Mode with various Teams (who have their own trackers).

     

    When they copy and paste these Activities and Tasks to their Sheet the hierarchy is lost, defeating the purpose of creating the Checklist.

     

    Is it possible to allow Hierarchy to be copied without having to Copy Rows?

    · Share on FacebookShare on Twitter
  • Travis
    Travis Employee

    Shailendra, as long as all the copied cells are included in a hierarchy, the hierarchy will be included when you copy and paste. 

    · Share on FacebookShare on Twitter
  • Shailendra Singh
    Shailendra Singh ✭
    edited 11/04/15

    Thank you Travis.

     

    In certain cases it works, but most other times hierarchy is not replicated.

    I have tried Paste Special and using modifier Keys (Ctrl, Alt, Shift).

    Please see these Screenshots and advise me what I am doing wrong.

     

    Cells Copied with Hierarchy

     

     

    Same Cells are Copied WITHOUT Hierarchy in another Sheet.

     

    (unable to paste Screenshot here!).

     

     

    Smartsheet-2-Cells-Pasted-with-Hierarchy.png

    · Share on FacebookShare on Twitter
  • Shailendra Singh
    Shailendra Singh ✭
    edited 11/04/15

    Thank you Travis. 

    I am unable to get this result consistently. 

    Below are Screenshots when I tried copy-pasting heirarchy.

    In some cases it works, whereas it fails in other cases. 

    Please advise what I am doing wrong.

    Thank you.

     

     

    Cells with Heirarchy copied.

     

    Smartsheet-1-Cells-Copied-with-Hierarchy.png

    Smartsheet-2-Cells-Pasted-with-Hierarchy.png

    Smartsheet-3-Cells-Pasted-WITHOUT-Hierarchy.png

    · Share on FacebookShare on Twitter
  • Travis
    Travis Employee

    Shailendra, are you copying and pasting between browser tabs or from within the same Smartsheet tab (and just switch sheets from within Smartsheet)? 

     

    I have found if I copy and paste from within the same Smartsheet tab, it works. When I have multiple Smartsheet tabs open and copy and paste between them, it will not work.

    · Share on FacebookShare on Twitter
  • Shailendra Singh
    Shailendra Singh ✭

    Copying from one tab in Smartsheet to another tab within same Browser window. 

    When I tried copying to another Browser window, it failed to copy formatting either.

     

     

    After this happened, I closed all other windows where Smartsheets was open and tried again. Similar inconsistent outcome. 

    That is why I am unable to understand what is causing it. 

    · Share on FacebookShare on Twitter
  • Travis
    Travis Employee

    Shailendra, rather than copying between different browser tabs, try to copy/paste from within the same browser tab. 

     

    From my tests, copying between multiple browser tabs will not typically include hierarchies but copying from within the same browser tab, works every time. 

    · Share on FacebookShare on Twitter
  • gregjohnsondsm43126
    gregjohnsondsm43126 ✭✭✭✭

    Travis is wrong.  At least on version from 4/6/2018.  Copy within the same smartsheet does not copy the hierarchy.  It is possible it did in the past, but Travis gave no evidence.      Shailendra did a good job of outlining the problem and this issue is pretty important.

    · Share on FacebookShare on Twitter
  • gregjohnsondsm43126
    gregjohnsondsm43126 ✭✭✭✭

    Ok, I take that back.  Travis is correct sometimes.  If the parent row is expanded and you include children, then sometimes it works.  But not everytime.  And never if the parent row is collapsed.

    · Share on FacebookShare on Twitter
  • jzarate26716
    jzarate26716 ✭

    Don't know if this helps, but it seems to work for me.  The column header I have as a "Name".  Right click and select "expand all" so entire sheet hierarchy is shown.  Then select as others have stated from row x (top of desired hierarchy and hold shift) to row N.  Then copy and past in empty row.  Entire hierarchy seems to stay intact.

    · Share on FacebookShare on Twitter
  • Mireille Dode-Inkimo
    Mireille Dode-Inkimo ✭

    I'm encountering the same issue.

    I'm trying to copy from inside the same browse.

    Hierarchy copy is inconsistent - for some blocks it works, for others it doesn't. 

    This is very frustrating. @Travis - are you able to reproduce the issue we are all having here? If so, can you please outline the approach you are taking that is making it work for you? 

    KR

    M

    · Share on FacebookShare on Twitter
  • Mireille Dode-Inkimo
    Mireille Dode-Inkimo ✭

    Hi

    I've noticed one regularity

    - if I copy a set of contiguous rows, the hierarchy is copied

    - if on the other hand, I apply a filter (which removes from view a group of elements, in my case a block of rows which are not hierarchically related to the other rows, but which are in the middle of them), then the copy/paste of the "filtered" rows does not maintain the hierachy. 

    Hope this helps sort out the issue. 

    KR

    M

    · Share on FacebookShare on Twitter
This discussion has been closed.

Categories