Kanban columns based on formula field

[John_Beaudoin]

Is there any way to use a Kanban view organized by a formula field? I have a workflow table with 15 checkbox fields for milestones (I tried single select first – it really isn’t intuitive for the users). I created a formula that groups the milestones into 5 “Macro Phase” groups. This works well in the grid view when grouping by Macro Phase, but it would be AWESOME to visualize it with a Kanban view.

I would rather not rely on a user having to select the Macro Phase, because that data could conflict with the checkbox data.

[Chris_Malherbe]

+1 for this, very useful feature.

Any update?

[Rasmus_Geertsem]

+10 for this.

I just created formulas to automatically decide on the status of a task, based on due dates and activity. It proved to be useless because Kanban views don’t recognize the outcomes of the formulas.

[Elias_Gomez_Sai]

Why do you want Kanban if you are not going to move your records, because it is automatic?

[Rasmus_Geertsem]

Hi Elias,

The formula automatically updates the status of the record. So is a Kanban view would be possible, the records would move between the different statuses, but automatically.

[Bettina_Horvath]

Is there any update? I just had the EXACT same thing happen. Spent 2 hours working on that formula with all sorts of IF statements and then it turned out not to work for the Kanban view.
I want it for the pretty optics to show how the workflow is not to manually move the cards around.
I know I can group but that’s an entirely different view.

[Joshua_Abraham]

yes
title can use
really need
better function than trello
airtable’ strong side

[Kasie_Chaplick]

+10000 on this
I have my task’s status generated by a formula that looks at the due date. I would love to populate today’s tasks in a stack and the rest of my todos in another stack, then be able to update to done.

[Sebastian_Siebe]

+1000
Hard to believe this doesn’t already work

Anyone has a workaround for this?

[Rachel_Pearson]

As a workaround I have created a separate single select column, and use zapier to update this column based on the columns in airtable that I’m trying to use. Not ideal but seems to be working!

+1 kanban using formula field would be helpful though

[Sebastian_Siebe]

Oh wow! Creative! Seems overkill for what we are trying to achieve, let’s hope there is an alternative soon.