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.

Moving rows

Carl Schultz
Carl Schultz ✭✭✭
edited 12/09/19 in Archived 2016 Posts

Is there a way to move rows from one sheet to another and keep all the cell formulas that go with it?


  • KrisWalsh
    KrisWalsh ✭✭✭✭✭

    This might be a good Enhancement Request. It would be extremely handy if I needed this feature more.  


    I've always done it per the guide: Moving Rows, Columns & Cells


    Formulas and predecessors won't be preserved, but you can copy and paste them between the two sheets


    Hope this helps! 



  • J. Craig Williams
    J. Craig Williams ✭✭✭✭✭✭
    edited 02/26/16

    Carl & Kris,


    This is what I use the free version of Zapier for (www.zapier.com)

    Free gives you:


    • 5 Zaps
    • Zaps run every 15 Minutes
    • 100 Tasks/month

    A Zap is an instance of the automation.

    I currently have two sheets that I move from. (So 2 Zaps)

    And I do it less than 100 times a month so no danger of hitting that until I find more uses for Zapier (actual or testing)


    The first one took only a few minutes to get up and running. 

    Unfortunately as I was writing this, I realized I might not have formulas in the orginal sheet -- and sure enough I didn't. So I tested it ... and it did not bring over the formula. Frown

    So a slightly longer check reveals it probably won't.


    So nevermind.





This discussion has been closed.