Automation not Automating!
Hello.
I'm using the Smartsheet Individual Productivity Hub template and I can't get the Completed Tasks automated workflow to work.
I've checked the automation and the condition is set that if the status is changed to complete, the action is to move the rows to another sheet. The destination sheet has been set.
But, when I change an action to complete, nothing happens. If I got and manually run the workflow, it moves all rows.
What am I missing?!
Thanks in advance.
Katie
Best Answer
-
Hey @KatieDi
You have to set a condition so only the rows with the Status complete will move to the next sheet.
At the moment, because there is no condition, when a row changes to Complete, it will move all rows over to the other sheet.
Try adding a condition like that, Where Status... has any of... completed.
This should solve the problem.
The move rows automation sometimes takes a minute or two so try and save the page, leave and open it again.. usually works for me.
Hope that helps!
Itai Perez
Reporting and Project Manager
If you found my comment helpful any reaction, Insightful, Awsome etc... would be appreciated🙂
https://www.linkedin.com/in/itai-perez/
Answers
-
Hey @KatieDi
You have to set a condition so only the rows with the Status complete will move to the next sheet.
At the moment, because there is no condition, when a row changes to Complete, it will move all rows over to the other sheet.
Try adding a condition like that, Where Status... has any of... completed.
This should solve the problem.
The move rows automation sometimes takes a minute or two so try and save the page, leave and open it again.. usually works for me.
Hope that helps!
Itai Perez
Reporting and Project Manager
If you found my comment helpful any reaction, Insightful, Awsome etc... would be appreciated🙂
https://www.linkedin.com/in/itai-perez/
-
Amazing Itai, thank you.
That was all it needed and it's now working.
Thank you for coming back to me so quickly.
Have a great day. 😀
Katie
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.1K Get Help
- 348 Global Discussions
- 199 Industry Talk
- 427 Announcements
- 4.4K Ideas & Feature Requests
- 133 Brandfolder
- 127 Just for fun
- 127 Community Job Board
- 455 Show & Tell
- 28 Member Spotlight
- 1 SmartStories
- 282 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!