When you install the software development app, it starts with “Severity” and “Priority” single-select fields on the Bug type. The options have names like “High”, “Medium”, “Low”, but they also have a number value that’s accessed in a “Pain” formula. I’d like to do something similar for the Effort f…

This is tricky. You can add Value field to Single Select as shown below. In fact Single Select is just a Type under the hood and you can add as many fields as you wish and access them via Formulas or API

This is a great feature. Wish I’d known about it sooner. Given that a single-select is just a type under-the-hood, is it possible to link a single-select field to more than one parent type? Or even the same type more than once? Sometimes it’s useful to have the enumerations defined once but used s…

It is not possible to link a single select field to more than one parent type. Otherwise things can go crazy :slight_smile: Multi-select is also just a type.

Hi all, Just wondering, if I wanna assign a single-select value in a formula, for example to update the state of a Feature based on all the User Stories in it (i.e. once all US are Done, mark the Feature as Done). I do not see how this answer solves that? I remember @ChrisG highlighting that I can…

Assuming you have Feature → User Stories, then I can think of a couple of ways to do it: You can have an automation in the User Story db that runs when the state becomes Done, and updates the parent Feature’s State (based on a formula that checks that there are no linked User Stories that are not …

Thanks, @Chr1sG ! I see where I went wrong :man_facepalming: That said, it still doesn’t feel neat, because what I want is: Have an automation that updates the Feature whenever a User Story state changes: It’ll check if the parent Feature has any remaining open User Stories and if not, sets the Fe…

You’re right, that both my suggestions are sub-optimal. I know that @antoniokov is aware of this use case, and it is likely that we will support the ability to set a state just by assigning a string. in this case you could use suggestion #1 without needing the convoluted workaround.

Thanks @Chr1sG ! Though I would think that assigning by type (i.e. Features.States.Done) is better than assigning by string "Done" because: It’s more robust in case the single-selects or multi-selects get renamed It’s in line of how one can assign an entity in a relationship :pray:

Well, I kinda glossed over how we are thinking of implementing it by saying ‘string’. It is possible/likely that users would actually be able to type something like: [[Done]] which would map to a State ID in the backend, so that if the State options were renamed, the formula would still work (and …

Glad to hear, thanks! :slightly_smiling_face:

Just re-visiting this as I came across another case where I have a relations hip to a parent with multiple single-selects for classification, that I wanted to summarise in a child in order to make a Board View less cluttered.

Ability to set single-select formula value?

Get Help

Chr1sG November 26, 2024, 8:43am 22

It depends. Not using an if…then… construction, but you can use a formula to propagate a value.

Topic		Replies	Views
Button formula: How to update a single-select field Get Help	16	1616	September 22, 2023
Formulas can't make use of Single Select fields? Bugs & Issues formulas	2	477	July 15, 2022
Setting dropdown value via formula Get Help automations , formulas	2	320	December 18, 2023
Single Select: string values Ideas & Features	6	45	April 28, 2026
To easily change Single Select Field to Multi Select one Ideas & Features	2	58	August 25, 2025

Ability to set single-select formula value?

Related topics