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
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
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
- 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!