This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
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
or
Where date is within the last 3 days
and
Where check box ...
