automate a reminder based on "Last updated"?

System

This discussion was created from comments split from: System Column - Last Modified.

Hunter Brawn

Is there currently a way (without Zapier) to automate a reminder based on "Last updated"?

Specifically, I have a column tracking when each row was last updated. I would like an alert sent out when that date gets too stale.

Paul Newcome

@Hunter Brawn I would suggest inserting a hidden helper column (flag type in this example) with a formula that would automatically flag the row when "Last Updated" is too far in the past.

=IF([Last Updated]@row<= TODAY(-10), 1)

Then you would set up your automation to run when the row is flagged.

Hunter Brawn

Thanks! I've set this up and now I'm waiting to see if it works.

Paul Newcome

Happy to help. 👍️

Hunter Brawn

So it works, but when it goes off it resets the date-counter on every row that triggered, which makes it a bit of a hassle to go back and find each one once the notification(s) get buried.

Should I remove those cells from the tracking for the "last updated" counter?