Workflow automation - copy to another sheet sheet.
OK, so I've set up a task list sheet in Smartsheet. I've also set up a separate sheet called routines. The idea was that through automation (copy row), when a routine task was due to be completed it would automatically (and repeatitively) be added to my task list.
The routines sheet looks like this (task and assigned to columns redacted):
On this sheet the start date auto updates through a formula - updating each day at midnight for daily tasks, at midnight once a week for weekly tasks etc.
I have added an automated workflow, which looks like this:
Where once the start date for a row is reached the row should copy to the task list. But it doesn't, at least not repetitively, it seems to copy only once, i.e. the first time I run the automation.
So what am I doing wrong?