Moving rows

Carl Schultz

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

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

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. 

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

 

So nevermind.

 

Craig