Todo List Priority change with Date


I have a Todo List with Prio and Dates. A Todo/Task can have a Prio and a dueDate. I want the Prio to be higher if the DueDates gets nearer. I tried Automations, but the IF won work. I tried:
[To-Do List RV].Termin<= (Today() + 4) but theres is no output.

What would be the correct IF?


Something like this? This works by having a second, hidden priority field that is calculated. You probably shouldn’t be overwriting your manually entered priority column.


THANKS, i was hoping not to make an extra row, but this helps. what would be the overwrite command?


I don’t know what you’re asking, sorry.