Automation stopped working
I have a sheet that holds the anniversaries and birthdates of each employee, and a few automations to send a reminder 1 week before and 1 day before. Since I made the sheet last July, it has worked fine, but now I'm seeing some issues come up. What I received this morning was a correct one, along with one that was 2 days passed (3 days since the last email should have been sent). How can I fix this, I have double checked the automations and none of them have changed. The dates are a formula that updates to the current year so that it can be used as a trigger for the automation, and these issues started with the new year, so I think that might be related.
The formula: =date(year(today()), month([Birthday]@row), day([Birthday]@row))
It is working for most still, but I can't figure out why this one came out wrong, and another one was missed entirely.
Help Article Resources
Check out the Formula Handbook template!