Single Select, Formulas and Formatting Kanban View

[Mark_Molter]

I want to be able to use the Kanban view with Single Select options that are made based on conditional formulas.

[Olly_L]

I also think this would be very useful, we want to track tasks by which Sprint # they are in, but it would be useful to have a simplified Kanban view that just showed “This sprint” and “Next sprint”. This sort of solution would be very easy if you could populate a Single Select from a formula.

[Nico_De_Ceulaer]

I am interested in the same feature (but without the kanban view part).

I would like to be able to define a formula field to will yield something that behaves as a single select field. I am aware that i can easily make a formula that results in a couple of text strings.
But I would like to have my users to have the nice colours we get from a single select cell as well.

Refer to this community question for the same request:

Is it possible to define a single select field's value through a formula? Formulas

Currently, formula fields support numeric, date and text output only. Are there any plans to extend formula field to work with other types of output (such as the single select field)? A bit of context: I have 3 single select fields (let’s call them A, B, and C) which represent the status of a task. Statuses may have one of the following options: Todo, Doing, Paused, and Done. For example, given some task, it could have the A field as Doing, B as Paused, and C as Todo. With that in mind, I’d li…