I’m looking for an automation that can change a date field. Basically I want any dates before today to update to today’s date (in a date field).
Trigger: if Status Due is before today
Action: Update Status Due date to today’s date
I’m looking for help to write a formula that will help filter records that meet these requirements. I can’t seem to get it done using the filter function.
Where date is within the next week
Where date is within the last 3 days
Where check box ...