Automating The Stacking Section in the Kanban View

[Abby_Skrabak]

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.

[ScottWorld]

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.

[Jeffpdoes]

Hey Abby & Scott,

I realize this is an old post, but I was struggling for an answer around this same idea, and I've figured something out.  I have my "Tasks" Kanban stacked by a Linked Field "Projects", and it does in fact order them alphabetically in this case.  I was able to create a new Primary formula field for my Projects, which appended a prefix number to the name of the Project, based on a single-select "Priority" field.  And then the stacks automatically update as the priorities are changed.

I'm sure you could come up with a similar formula based on "Today" to sort those Kanban stacks, especially with the new AI formula generation.