# Formulas can't make use of Single Select fields?

**URL:** <https://community.fibery.io/t/formulas-cant-make-use-of-single-select-fields/3075>\
**Category:** Bugs & Issues\
**Tags:** formulas\
**Created:** [July 15, 2022, 4:32pm UTC](https://community.fibery.io/t/formulas-cant-make-use-of-single-select-fields/3075 "2022-07-15T16:32:25Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![Matt\_Blais](https://sea2.discourse-cdn.com/flex020/user_avatar/community.fibery.io/matt_blais/32/1464_2.png) [@Matt\_Blais](https://community.fibery.io/u/Matt_Blais)\
**Post date:** [July 15, 2022, 4:32pm UTC](https://community.fibery.io/t/formulas-cant-make-use-of-single-select-fields/3075/1 "2022-07-15T16:32:25Z")

</div>

It seems not possible to make a Formula that does anything useful with a Single Select field.

E.g., If I want to get the Name of a Single Select field’s **current selection** I need something like:

```auto
[SingleSelectField].CurrentSelection.Name

```

but I can’t figure out a way to do that.

I assume the same problem applies to Multi-Selects, though I haven’t tried them.

If this did work, it might make it possible to have something like a “Dynamic Single-Select” type, which could populate its options dynamically for each entity, based on a formula. That’s what I was trying to simulate when I ran into this issue.

---

<div class="post-metadata">

**Author:** ![Chr1sG](https://sea2.discourse-cdn.com/flex020/user_avatar/community.fibery.io/chr1sg/32/3941_2.png) [@Chr1sG](https://community.fibery.io/u/Chr1sG)\
**Post date:** [July 15, 2022, 7:51pm UTC](https://community.fibery.io/t/formulas-cant-make-use-of-single-select-fields/3075/2 "2022-07-15T19:51:31Z")

</div>

> [@Matt\_Blais](#):
>
> If I want to get the Name of a Single Select field’s **current selection**

`[SingleSelectField].Name`  
ought to work fine, unless I’ve misunderstood.

For multiselects, you would need to aggregate the names:  
`[MultiSelectField].join("Name",", ")`

---

<div class="post-metadata">

**Author:** ![Matt\_Blais](https://sea2.discourse-cdn.com/flex020/user_avatar/community.fibery.io/matt_blais/32/1464_2.png) [@Matt\_Blais](https://community.fibery.io/u/Matt_Blais)\
**Post date:** [July 15, 2022, 9:20pm UTC](https://community.fibery.io/t/formulas-cant-make-use-of-single-select-fields/3075/3 "2022-07-15T21:20:01Z")

</div>

Thanks - it turns out my issue was actually “Can’t change type of Formula field” – i.e., once I’ve defined a Formula Field, I am not allowed to change it to return a different type.

It would be helpful if the error message explained this limitation.

---

<div class="post-metadata">

**Author:** ![Chr1sG](https://sea2.discourse-cdn.com/flex020/user_avatar/community.fibery.io/chr1sg/32/3941_2.png) [@Chr1sG](https://community.fibery.io/u/Chr1sG)\
**Post date:** [December 20, 2024, 1:18pm UTC](https://community.fibery.io/t/formulas-cant-make-use-of-single-select-fields/3075/4 "2024-12-20T13:18:35Z")

</div>