Why isn't the workflow triggering and moving the data to another sheet?
Hi,
I have the following workflow set up where the data needs to move to the delivered sheet once the date is in the past. For some reason, the workflow is not working. Both sheets have the exact same column headings. Can someone review and let me know what's missing?
Answers
-
You're asking for the automation to be triggered when a date is reached, but only if the date is in the past. That will never happen, because by definition, when a date is reached, that date is in the present. Instead of "Run once" "on," try "Run once" "1 day after". This will cause your automation to run the day after the Course End Date.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.1K Get Help
- 380 Global Discussions
- 212 Industry Talk
- 444 Announcements
- 4.6K Ideas & Feature Requests
- 140 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 450 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 290 Events
- 35 Webinars
- 7.3K Forum Archives
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!