I'm sure I'm missing something simple, but I'm having trouble creating an automated reminder that goes out when an item is 25 or more days past the completion date in my sheet. There's a report that needs to be run about a project, but it needs to be run after at least 25 days have past from the completion date. I want the reminder to go out until the report is complete and the necessary cell is filled in.
Right now the automation is triggered to go out once a week for all items where a particular cell is blank and it is in the last 25 days from the project completion date. But, that means the reminder goes out when it is less than 25 days from the completion date. If I select "is greater than or equal to" instead of "is in the last (days)," I have to select a specific date, which I don't want to do.
How do I get an automation that goes out when an item is equal to or greater than 25 days in the past?
