Copy/Move Row Automated Workflow Not Working
Hi there,
I have two very basic workflows set up - when the "status" column of a row in one sheet is changed to "review", I want that row to be copied to another sheet. The second workflow is the exact same, but when "status" is changed to "complete" I want that row to be moved to another sheet. The workflows are not triggering despite refreshing, recreating the sheets I want them to move to, etc. - any advice? I've confirmed they are not being copied/moved to the bottom of the sheet.
Thank you!
Best Answer
-
Make sure that they start at one value that is not in the workflow, and save the sheet. Next update the value, and save the sheet. Now wait 5 minutes and refresh the sheets. Is the workflow enabled? sometimes it is disabled and that is why its not working.
For your second status you have 3 values. Try to determine if you need a separate workflow for each value. It might be searching for a cell with all three values in it.
Answers
-
Make sure that they start at one value that is not in the workflow, and save the sheet. Next update the value, and save the sheet. Now wait 5 minutes and refresh the sheets. Is the workflow enabled? sometimes it is disabled and that is why its not working.
For your second status you have 3 values. Try to determine if you need a separate workflow for each value. It might be searching for a cell with all three values in it.
-
That worked, thank you! Looks like I just had to set everything up in the right order. The second status with the three values worked after I followed the same steps you outlined for the first one.
Now the row that was copied into the other sheet is getting duplicated :) I think I saw a question about this elsewhere in the community so I'll see if I can figure out how to fix that there.
Thank you so much!
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.8K Get Help
- 434 Global Discussions
- 138 Industry Talk
- 470 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 65 Community Job Board
- 486 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!