Formula to move a row to another sheet?

Loann McGee

Good morning,

I'm hoping I can formulate a column so that if the checkbox is checked, it will move that row to another specified sheet.

Can this be done?

If column A is checked, move to Sheet B is the basics, but formulas always mess with me.

Blessings,

Loann

Tim Meeks

Loann,

Dno't know of any way this can be done with a formula. We have some developers here who are .net programmers and have used the SS APIs to move rows from one sheet to another. The only ways I know of are manually or by a tool such as Azqua.

Good to hear from you! hope all is well.

Tim

Loann McGee

Thanks, Tim! Manual it shall be - or I'l teach them all about the filter option. ;-)

Richard Rymill SBP

Loann Tim is right but to add....

What you describe can be done fairly easily using Zapier. That will not MOVE but will COPY that row to another sheet creating a NEW ROW in the landing sheet.

What might be just easier?... is when in the Row you wish to MOVE, highlight the row and Right Click "Move to another sheet" and you can MOVE several at one go, after a filter or a sort. Would that be easier?

Hope that helps

RichardR

Loann McGee

I do the latter - I was asked if it can be automated, which I didn't think was the case (at least not easily). And for the sheet we're working from, it isn't cumbersome in the least to manually select the row(s) and move.

Thanks, Richard!

Stan Schultz

I did a riff on RichardR's suggestion. Completed tasks are conditionally formatted to change to light gray text with a Strikethrough style applied. This leaves them in place until I've reviewed with everyone I need to review with...

I also created a checkbox column called Archive. When I'm ready to cleaned up and move Completed Items, I check the Archive box and apply a filter so that only completed items show. I select all the completed items that I've set to archive, and use the "Move to another sheet command."

Still not automated, but make it easy do do batches.

Richard Rymill SBP

Nice one Stan, glad that works for you and the amount of manual labour is very little and compared with automation...does give you the opportunity to review the detail before archive, just in case of errors.

If the sheer volume of this work did get too much, we can show you a way using API linkages to automate the activity but there is a cost, so if you are happy as you are that is good.

Richardr