Move automation is moving all items (not just the trigger)

jacquedale

I have a sheet that I want to move "complete" items to an archive sheet. I have done this with many other sheets, but for some reason when I set this up and run it- it moves all items (even those that don't meet the criteria) to the archive.

I couldn't undo the incorrect move, and I couldn't even paste the info back in. I had to create a new sheet. Which I tried it again and it is still not working.

Andrée Starå

https://community.smartsheet.com/discussion/109352/move-automation-is-moving-all-items-not-just-the-trigger

Hi,

I hope you're well and safe!

Do you have Parents and Children? If you trigger it for a Parent, it will bring all children underneath over too.

Was that the issue?

Can you share some screenshots? (Delete/replace any confidential/sensitive information before sharing) That would make it easier to help.

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 support the Community 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!

ErinHell

@jacquedale did you ever figure this out? I am guessing its because you have items grouped. I have this same issue and I am trying to figure out how to accomplish this too.

Andrée Starå

 @ErinHell

I hope you're well and safe!

Can you elaborate on how you'd like it to 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 support the Community 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!

jacquedale

Thanks for all of the input. I was never able to figure out the problem on my own but I spoke to tech support at Engage last wee k and we finally identified that it was happening only when I performed the "run now" check on the whole document. So I had to add an additional condition 😁

Laurie Mason

I have had this issue when using the "Run now" option also. The weird thing is it doesn't seem to always move all rows. @jacquedale Can you share or elaborate on the additional condition added that helps avoid this problem?

cvalletta

I just had this exact issue and all of my data is gone. Did you all ever figure out how to fix it?

HectorH

Same issue. I didn't realize it was the Run Now function that would be part of the problem. What was the Condition you added?

https://community.smartsheet.com/discussion/comment/396719#Comment_396719

DianaFG

Argh, this just happened to me to! I'd love to know what condition you added Jaquedale. I'd also like to find a way to undo this without having to reacreate my entire (large) SmartSheet @Smartsheet Hero

DianaFG

I just got help with this by phone! I submitted the question as a ticket and they called back fast, thank goodness. I had to move the rows back to the original sheet (by highlighting the rows, right clicking, and picking Move Rows To Another Sheet). To avoid the problem, the condition to add to the workflow is the same as your trigger. Just duplicate. This works because the "Run Now" ignores the automation workflow. This is a terrible set-up, as we have learned, The reason why they do it is because "most" of the time people "Run Now" when wanting to test something out before date is reached, yet date is not the only option of a trigger.