I am having an issue with an automation and would love some guidance. The automation is intended as follows (w/ pics below).
Trigger: When Production Status field IS “Scheduled”
AND Review Status field IS “Approved”
AND Publish Date field (actually called Archived Publish Date in my table) IS “before today”
Action: Update records’ Production Status to “Live”
I can see that the tests are working, and the automation triggers when I add a new record meeting the above conditions, but when I run the automation, nothing changes to my existing records meeting those conditions. I was really hoping that it would update all pre-existing “Scheduled” records to “Live” to save time on data entry.