Hi! I’m trying to create an automation that is basically:
If publish date is yesterday and status is not ‘published’ then the publish date updates to today.
I saw some people mentioning creating a TODAY() formula field and using that as a dynamic trigger. Questions with this:
- How will this field affect already existing records?
- What needs to be added between the parentheses of the TODAY() formula?