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

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!