I have a custom field called “Timeframe Due” with the following options: Today, Tomorrow, This Week, Next Week, This Month, and Next Month. I would like to create an automation that updates the Timeframe Due field whenever the task’s due date changes.
The challenge I’m running into is that there doesn’t appear to be a way to evaluate whether the new due date falls within a specific relative timeframe (e.g., next week or next month). For example, if I change a task’s due date to next Wednesday, I would like the Timeframe Due field to automatically update to “Next Week.”
I rely on the Timeframe Due field to organize my view, so having it update dynamically based on the due date is important to my workflow.