# Ability to set single-select formula value?

**URL:** <https://community.fibery.io/t/ability-to-set-single-select-formula-value/627>\
**Category:** Get Help\
**Created:** [March 29, 2020, 11:15pm UTC](https://community.fibery.io/t/ability-to-set-single-select-formula-value/627 "2020-03-29T23:15:41Z")\
**Posts on this page:** 4\
**Page:** 2

<div class="post-metadata">

**Author:** ![Wilco\_Boode](https://sea2.discourse-cdn.com/flex020/user_avatar/community.fibery.io/wilco_boode/32/9985_2.png) [@Wilco\_Boode](https://community.fibery.io/u/Wilco_Boode)\
**Post date:** [November 26, 2024, 8:22am UTC](https://community.fibery.io/t/ability-to-set-single-select-formula-value/627/21 "2024-11-26T08:22:50Z")

</div>

I was looking for a similar option, but I cannot find it either.

Basically, I want to set a single select field based on an if statement in a formula. But I cannot manually provide a State.

I expected that I could get the values in the database (aka, get all values associated to the single select), and get the 1st, 2nd, 3rd option, but I cannot get it to work. Is there anyway to set a single-select value from a formula?

---

<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:** [November 26, 2024, 8:43am UTC](https://community.fibery.io/t/ability-to-set-single-select-formula-value/627/22 "2024-11-26T08:43:38Z")

</div>

> [@Wilco\_Boode](#):
>
> Is there anyway to set a single-select value from a formula?

It depends. Not using an if…then… construction, but you can use a formula to [propagate a value](https://community.fibery.io/t/june-1-2023-selects-in-automation-formulas-custom-button-messages/4534).

---

<div class="post-metadata">

**Author:** ![Wilco\_Boode](https://sea2.discourse-cdn.com/flex020/user_avatar/community.fibery.io/wilco_boode/32/9985_2.png) [@Wilco\_Boode](https://community.fibery.io/u/Wilco_Boode)\
**Post date:** [November 26, 2024, 9:06am UTC](https://community.fibery.io/t/ability-to-set-single-select-formula-value/627/23 "2024-11-26T09:06:56Z")

</div>

I expected as much, transferring values between entities is indeed very easy, it was the if then statements that I was wondering about.

Would be nice to have in the future to retain the low/no code philosophy

---

<div class="post-metadata">

**Author:** ![helloitse](https://sea2.discourse-cdn.com/flex020/user_avatar/community.fibery.io/helloitse/32/498_2.png) [@helloitse](https://community.fibery.io/u/helloitse)\
**Post date:** [November 26, 2024, 6:52pm UTC](https://community.fibery.io/t/ability-to-set-single-select-formula-value/627/24 "2024-11-26T18:52:21Z")

</div>

You can create the If/Then logic on a field in the database that triggers the automation. Then propagate the select field with that formula.

[Previous page](https://community.fibery.io/t/ability-to-set-single-select-formula-value/627.md?page=1)