Skip to content
  • Try Smartsheet

    • Smartsheet Basics

    Smartsheet Basics

    Ask questions about the core Smartsheet application: Sheets, Forms, Reports, Dashboards, and more.

    Automated copy from row to a new row in the same and single sheet.

    ✭✭✭✭
    in Smartsheet Basics

    Hello Smart-Heads!

    This one might sound trivial, but I am looking for an automation to copy limited amount of information from one row to a new row in the same sheet.

    The sheet contains initial generic information. Column E can be duplicated across the sheet with unique values from column F, assigned to column E, example:

    image.png

    The desired outcome is to automatically create a row below with information from A-E.

    Option 1:

    Highlight + "pull down", not acceptable as changes last digit

    image.png

    Option 2:

    Optional: Insert above / below

    Highlight + "copy" + paste below or in created row.


    The automation is required to ensure that the reviewers don't make stupid mistakes and fail to paste correct value in column E.


    Thanks,

    Roman

    · Share on FacebookShare on Twitter

    Best Answer

    • ✭✭✭✭✭✭
      Answer ✓

      @Romano el Polako You can use a helper sheet. What you will do is set up an automation to Copy the row to another sheet. On the helper sheet, you can then set up an automation to Move the row to the original sheet, thus creating a duplicate. If you need certain fields blank, you would also set up an automation for new sheets that changes certain cells to blank.

      Hope that makes sense and helps you.

      · Share on FacebookShare on Twitter

    Answers

    • ✭✭✭✭✭✭
      Answer ✓

      @Romano el Polako You can use a helper sheet. What you will do is set up an automation to Copy the row to another sheet. On the helper sheet, you can then set up an automation to Move the row to the original sheet, thus creating a duplicate. If you need certain fields blank, you would also set up an automation for new sheets that changes certain cells to blank.

      Hope that makes sense and helps you.

      · Share on FacebookShare on Twitter
    • ✭✭✭✭

      Hey @Eric Law

      Thanks for your response, yes this actually makes a lot of sense:

      1. check box as a trigger for copy to helper sheet.
      2. automation in helper sheet with 'move when new row is added"
      3. minor adjustments with blank / copied content.

      Thanks, will check it and come back to this threat!

      Romano

      · Share on FacebookShare on Twitter

    Sign in
    Try Smartsheet

    Quick Links

    Categories

    Trending in Smartsheet Basics

    Help shape the future of Smartsheet.
    Share your ideas and feature requests.

     Watch video