Can I use automation to move a line in my sheet within the same sheet?

Grégoire Cadet

Hello,

I'm sorry, I know that this function is not possible. But i tried to workaround it.

I move the row to another sheet named helper sheet and then move it back to the first one and it will be added at the bottom of the sheet.

But there is a problem too, this message appear :

Then my automation is automatically disabled...

Thank you !

Andrée Starå

Hi @Grégoire Cadet

I hope you're well and safe!

Did you set it to trigger immediately?

Try to change it, so it's Triggered when a date is reached and set it to custom and repeat daily.

Did that work/help?

I hope that helps!

Be safe and have a fantastic week!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

Grégoire Cadet

Thank you @Andrée Starå

It works good !

Best regards,

GC

Andrée Starå

@Grégoire Cadet

Excellent!

You're more than welcome!

✅Remember! Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!