Automating The Stacking Section in the Kanban View

Hello, I am making a recurring weekly checklist, and I would like the Kanban Stacking view to change with the day. So today is Wednesday, I would like all my Wednesday tasks to be first and Thursday next, and Tuesday to be last. Unfortunately the stacking option only allows for alphabetical order.

I’m trying to think of a formula that would be dynamic and would assign the row a “1” if the due date falls on today’s weekday, and assign a “2” for tomorrow’s weekday, and so on. I’m not sure if that makes sense.

That’s just one thought, if there is an easier way I’d love to know.

It’s not stacked alphabetically, it’s stacked in the order that your single-select options are in. So if you change the order of the single-select options, you will get a different stacking order. There is no way to automate this, but you can manually do it.