How to copy automatically copy a row to the top of a sheet?

Brandon Morales

Hi, I just created a sheet that has an automated workflow that copies a row when a box is checked.

The problem is that my destination sheet is otherwise populated by a form that adds news rows at the top. When my automation copies a row it goes to the bottom- any way to change this?

Leroy Noriega

That's a great idea! Unfortunately the copy a row automation only copies the row at the bottom of the sheet.

Brandon Morales

Wow, really? that's pretty rediculous.

Follow up question, I created a filter that shows all of my rows that have the cell in the status column as blank and a few other criteria. Why are there a number of blank rows between my copied rows and the rows added by the form?