Todo List Priority change with Date

1

Hi
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?

2

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.

3

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

4

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