Automation Copy Rows

Angela Logie

Is there a way, when using the automation copy rows, to select which rows to copy from a sheet instead of it copying all rows?

Paul Newcome

You could set up a checkbox column, check the box for only that single row you want to copy, then include that box being checked as one of the conditions.

Andrée Starå

Hi Angela,

When you set up the the workflow you can configure when it should be copied over to the other sheet.

Would that 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!

Angela Logie

Yeah that part I have, so had scheduled it to copy at a set day/time. That worked, but it was transferring all rows in that sheet and not 1 row...which is all I needed?

Andrée Starå

You'll have to add a condition or similar, so it only copies what you want.

Is there anything specific that you could use to filter it?

Angela Logie

There isnt really a condition, its to pull the contents of a row into another sheet in order to have trend data week on week...so there isnt necessarily a trigger point other than the day/time

Andrée Starå

@Angela Logie

Ok.

How did it go? Did you get it working?

Paul Newcome

You could set up a checkbox column, check the box for only that single row you want to copy, then include that box being checked as one of the conditions.

Angela Logie

This worked a treat, thank you!!!

Andrée Starå

@Angela Logie

Excellent!

Glad you got it working!

Paul Newcome

Happy to help! 👍️

Mehran Bagherian

@Paul Newcome

Hi Paul,

I added a check box, and mentioned that in my condition, but it doesn't work. The automation copies all rows not just the row in picked. How can I solve this problem?

Actually the condition is for checking the requirement, but for copying there is no selection. I mean, I want to check something in a specific row, and copy the same row in another sheet when the condition satisfied.

The first action happens, but the second one (copying that specific row) does not. It copies all rows.

Mehran Bagherian

@Paul Newcome

Paul,

I found the problem. I was selecting project summary row, and it copies all rows because it copies the row plus children. That's why. Thank you anyway.