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.
Page 1 / 1
+1 for this, very useful feature.
Any update?
+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.
+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.
Why do you want Kanban if you are not going to move your records, because it is automatic?
Why do you want Kanban if you are not going to move your records, because it is automatic?
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.
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.
yes
title can use
really need
better function than trello
airtable’ strong side
+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.
+1000
Hard to believe this doesn’t already work
Anyone has a workaround for this?
+1000
Hard to believe this doesn’t already work
Anyone has a workaround for this?
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
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
Oh wow! Creative! Seems overkill for what we are trying to achieve, let’s hope there is an alternative soon.
+1 for Kanban view organized by formula
+1 from my side too, Kanban view is useful for more than acting as a way to update statuses of tasks through a workflow, it is a powerful visualization tool that needs to accept formula fields as a categorization option.
+1000. Is there an update on this capability? Just spent an inordinate amount of time on writing IF statements only to find that my formula field cannot be used in the Kanban view. Would very much appreciate this upgrade!
Hi, as a workaround you can also do automation in airtable that will update a single select record when the formula field is updated. It worked for me
Hi, as a workaround you can also do automation in airtable that will update a single select record when the formula field is updated. It worked for me
Has this workaround been stopped? I tried to use it and the formula column I wanted to use was greyed out.
Has this workaround been stopped? I tried to use it and the formula column I wanted to use was greyed out.
As your previous message says, you need to make an automation :grinning_face_with_sweat:
As your previous message says, you need to make an automation :grinning_face_with_sweat:
I haven’t written any previous messages, however I did attempt to do an automation and the automation would not allow updating a single select record by a formula field update. It would allow an automation relating to the first three field’s which were not formula fields.
I haven’t written any previous messages, however I did attempt to do an automation and the automation would not allow updating a single select record by a formula field update. It would allow an automation relating to the first three field’s which were not formula fields.
The message previous to yours…
I have tested and it works, there are several options to trigger when a Formula field is updated, por instance:
