Automation Help: How to change Status/Priority column based on approaching date

I need a visual that highlights approaching deadlines, so I created a “priority” status column with four labels (low-default, moderate, high, critical). I would like this column to automatically update as a due date approaches (e.g., when 1 week before due date-set priority label to critical). I tried adding four date automations, but it doesn’t seem to work - see attached image.

Any recommendations? I played around with Timeline, Progress, and “deadline” modes, but they seem dependent on the status of the project or incorporate notifications.