Dan Leeman and Vasken Bakalian, I believe you have previously wrestled with similar problems. I'm hoping you might enlighten me.
I've developed a solution that helps keep track of staff availability at a professional services firm. If a staff member's record has not been updated in the last 15 days, I want them to receive an email prompt. Here's the Staff app with the Last Updated system field:
I'm trying to trigger the email when Last Updated On is Today - 15 days:
However, it doesn't seem to trigger.
(Previously, I tried to trigger the automation based on a formula field. Then I discovered your earlier posts that indicated automation can't be triggered by a formula field value.)
Any suggestions will be greatly appreciated!