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.8K Get Help
- 376 Global Discussions
- 207 Industry Talk
- 440 Announcements
- 4.5K Ideas & Feature Requests
- 139 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 284 Events
- 33 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!