Automation Copy Rows
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?
Best Answer
-
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.
Answers
-
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!
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
-
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?
-
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?
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
-
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
-
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
-
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.
-
This worked a treat, thank you!!!
-
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
-
Happy to help! 👍️
-
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.
-
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.
