Time Based Automation did not run
I have an automation that runs based on my "Due Date" column at 11pm.
The formula in the "Due Date" column returns today's date if it is Tuesday, otherwise it returns the next Tuesday. FORMULA: =TODAY() + MOD(7 - WEEKDAY(TODAY()) + 3, 7)
It has been running fine every Tuesday evening since early February, but did not run last week (Apr 19) and is causing a lot of downstream craziness.
Also strange is that the automation says "Last ran on Apr 25" (last night), but it did not. Neither automation action (copy rows or clear cells) was executed. And it should not have run last night, because the "Due Date" condition was not met (the date in the column is Apr 26, today)