Copying rows from one sheet to another after checkbox trigger - copying whole sheet
Hi,
I have 2 sheets that I am setting up for inventory and ordering for my team. Sheet 'A' has a full inventory list, including a checkbox that will be checked when the inventory item needs to be ordered.
After a row is checked, I want it to copy over to my Sheet 'B'. I will use sheet B then to track the order process.
I have set-up the built-in Smartsheet workflow for copy/move a row, but I am having an issue. It is transferring the whole of sheet 'A' over, rather than just the row that I have checked. It also moves it over to the bottom of Sheet 'B'. Is there a way to just have the checked row copy over and for it to populate at the next available row?
I added a screenshot below of the workflow I created.
tysm!
Kayleigh
Answers
-
Hi,
I hope you're well and safe!
If you have a hierarchy with parents and children and the trigger/and condition include a parent, everything in that hierarchy will be copied to the next row in the destination sheet.If it's added with rows empty between them, you can try deleting the "empty" rows and see if that works.
Make sense?
Did that work/help?
I hope that helps!
Be safe, and have a fantastic day!
Best,
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
✅ Did my comment(s) help/answer your question or solve your problem? Please support the Community and me by marking it - Insightful 💡- Vote Up ⬆️ - Aweseome ❤️ - or/and as the accepted answer. It will make it easier for others to find a solution or help to answer! I appreciate it, thanks!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.
-
I don't have any hierarchy's present in this sheet, so I don't think that would be affecting it right now. I have added a screenshot below of my sheet. I want everything in red, that has been checked, to be copied to the other sheet. I don't want the unchecked ones to move, but they are.
-
Strange!
Is the checkbox for the other rows always unchecked?
Please double-check using the Cell-History feature.
Check how many rows are checked and how many are moved over to the other sheet.
How many was checked and how many was moved?
✅ Remember! Did my comment(s) help/answer your question or solve your problem? Please support the Community and me by marking it - Insightful 💡- Vote Up ⬆️ - Awesome ❤️ - or/and as the accepted answer. It will make it easier for others to find a solution or help to answer! I appreciate it, thanks!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.
-
They have always been unchecked, I just created the sheet this morning and checked the relevant items, but for whatever reason it is copying everything over.
-
Strange!
Can you share some screenshots?
(Please delete/replace any confidential/sensitive information before sharing) That would make it easier to help.
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.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.5K Get Help
- 424 Global Discussions
- 136 Industry Talk
- 465 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 145 Just for fun
- 62 Community Job Board
- 465 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 301 Events
- 39 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!