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.9K Get Help
- 410 Global Discussions
- 220 Industry Talk
- 458 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 137 Just for fun
- 57 Community Job Board
- 459 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 298 Events
- 37 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!