Moving Row Automation Not Working
I am having issues with what seems like a pretty simple straight forward automation task. We have a sheet where we are tracking projects status across our group. The goal is that when a project reaches 100% completed that the automation moves the row to a "Completed Projects" sheet. Please see the screen shots below and let me know if you have any suggestions. Thanks!
I put in 100% in that column and is not moving it to the Closed Projects sheet. Any help is appreciated
Best Answer
-
I was able to resolve the issue. Thanks for the help everyone
Answers
-
I am also having this problem with almost the same usecase. I have rows I'd like to archive that are in a declined or closed status. I have done it three different ways, and none actually function. Help!
Attempt 1:
Attempt 2:
-
Are all the columns from the source sheet present in the destination sheet?
If not, are you an Admin on the destination sheet? If the same columns aren't present in the destination, the system tries to create them as part of the move process; if you don't have Admin level access to the destination sheet, the system can't create the columns and so your row will not move.
*Note - Column names are case-sensitive, so make sure they line up exactly between the two sheets. They don't have to be in the same order, but "Completed Date" does not equal "Completed date" in column names.
Regards,
Jeff Reisman
Link: Smartsheet Functions Help Pages Link: Smartsheet Formula Error Messages
If my answer helped solve your issue, please mark it as accepted so that other users can find it later. Thanks!
-
I have been having Move Row automations fail recently as well. I am going to reach out to support tomorrow to see if they have any insight as to whether or not there is a system bug.
-
I have a series of cascading automated move row jobs in one of my solutions. They're all working correctly.
Regards,
Jeff Reisman
Link: Smartsheet Functions Help Pages Link: Smartsheet Formula Error Messages
If my answer helped solve your issue, please mark it as accepted so that other users can find it later. Thanks!
-
The only ones that have failed for me recently are when the trigger is based off of a formula, and even then it isn't all of them.
-
@JReisman27 I verified all columns are named the same and there are the same amount of columns on both the source sheet and the "Closed projects" sheet but the automation is still not moving the row. Any ideas?
-
I was able to resolve the issue. Thanks for the help everyone
-
What was the issue/solution?
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.
-
To be honest I am not sure, it just started working randomly
-
@PCC87 Ok. Main thing is that it's working again! 😉
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.
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.9K Get Help
- 439 Global Discussions
- 138 Industry Talk
- 471 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 67 Community Job Board
- 486 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives