# Formula based on Color of the single select option **URL:** \ **Category:** Get Help\ **Created:** [June 7, 2023, 11:06am UTC](https://community.fibery.io/t/formula-based-on-color-of-the-single-select-option/4563 "2023-06-07T11:06:28Z")\ **Posts on this page:** 7\ **Page:** 1
**Author:** ![Anish](https://sea2.discourse-cdn.com/flex020/user_avatar/community.fibery.io/anish/32/6786_2.png) [@Anish](https://community.fibery.io/u/Anish)\ **Post date:** [June 7, 2023, 11:06am UTC](https://community.fibery.io/t/formula-based-on-color-of-the-single-select-option/4563/1 "2023-06-07T11:06:28Z")
Just as an example, if I have a single select “status” and options like, In-Progress, Done with color yellow and green respectively. How to add a new formula field which should display something based on the color of the selected option from status field. ---
**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:** [June 7, 2023, 11:33am UTC](https://community.fibery.io/t/formula-based-on-color-of-the-single-select-option/4563/2 "2023-06-07T11:33:47Z")
I don’t think it’s possible. But I’m curious to know why you want to try this? Can’t you just use the status name in your formula? Or add an extra property for the purpose? ---
**Author:** ![Anish](https://sea2.discourse-cdn.com/flex020/user_avatar/community.fibery.io/anish/32/6786_2.png) [@Anish](https://community.fibery.io/u/Anish)\ **Post date:** [June 7, 2023, 11:46am UTC](https://community.fibery.io/t/formula-based-on-color-of-the-single-select-option/4563/3 "2023-06-07T11:46:33Z")
Hey @Chr1sG thanks for replying, The reason is I have multiple Statuses which represent as Done for example - Cancelled, Done, Complete . If I keep them Green colored I can condition based on color. also from dynamic point of view, later if the new statuses get introduced or changed existing ones i don’t need to change formulas. ---
**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:** [June 7, 2023, 12:02pm UTC](https://community.fibery.io/t/formula-based-on-color-of-the-single-select-option/4563/4 "2023-06-07T12:02:07Z")
It sounds like you should add a field to your status select options (a checkbox or a text field perhaps) which you can then reference in formulas. See here: [. | Fibery](https://the.fibery.io/@public/User_Guide/Guide/Select-Field-87/anchor=Select-Workflow-fields-in-Formulas--8e1edc34-2712-4e66-ab17-67754fa4c27f) Or make use of the ‘Final’ checkbox that exists already if it’s the workflow field. If/when you add more statuses, you can set the checkbox/text field as necessary. ---
**Author:** ![Anish](https://sea2.discourse-cdn.com/flex020/user_avatar/community.fibery.io/anish/32/6786_2.png) [@Anish](https://community.fibery.io/u/Anish)\ **Post date:** [June 7, 2023, 2:17pm UTC](https://community.fibery.io/t/formula-based-on-color-of-the-single-select-option/4563/5 "2023-06-07T14:17:29Z")
Yes I believe that will be better option. ---
**Author:** ![Anish](https://sea2.discourse-cdn.com/flex020/user_avatar/community.fibery.io/anish/32/6786_2.png) [@Anish](https://community.fibery.io/u/Anish)\ **Post date:** [June 15, 2023, 11:41am UTC](https://community.fibery.io/t/formula-based-on-color-of-the-single-select-option/4563/6 "2023-06-15T11:41:08Z")
Thanks @Chr1sG for this way to make it work in Formulas. But Looks like I can not use the same in Formula of Chart Calculations. Correct me if I am missing anything. ---
**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:** [June 15, 2023, 12:17pm UTC](https://community.fibery.io/t/formula-based-on-color-of-the-single-select-option/4563/7 "2023-06-15T12:17:22Z")
Indeed, select options are only available as text values (their names) in reports.