Copy rows to new sheet automation or better way to do this?

Justin Guest

Hi,

I have one sheet which has a form connected to it. Once someone submits the form, I have a drop down which I switch to "confirmed" when I have uploaded the submitters info.

Once I select, "Confirm" I want two specific cells in the row to copy to a different sheet. What would be the best way to do this? I have tried the copy row function, but cant seem to find a way to copy specific cells from the row to another sheet.

Thanks!

Andrée Starå

Hi @Justin Guest

Unfortunately, it's not possible at the moment to select which columns that should be included, but it's an excellent idea!

Please submit an Enhancement Request when you have a moment

As a possible workaround, you could either hide the columns that you don't need in the other sheet or use a cross-sheet formula structure instead to show the information in the other sheet when you switch to confirmed.

Make sense?

Would any of those options work?

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 help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!

Justin Guest

Hi Andree,

Hiding the columns may work - however is it possible to place a Created (Date) field with the date of when the row was copied over to the other sheet? I was already using the Created (Date) field in the first sheet and the option seems to be greyed out for me on the destination sheet where the rows are copied to.

Thanks!

Andrée Starå

@Justin Guest

Happy to help!

As long as you name them exactly the same it should work.

Did it work?