# Allow to return an empty value from a formula **URL:** \ **Category:** Ideas & Features\ **Tags:** formulas\ **Created:** [June 20, 2022, 9:22am UTC](https://community.fibery.io/t/allow-to-return-an-empty-value-from-a-formula/2983 "2022-06-20T09:22:46Z")\ **Posts on this page:** 7\ **Page:** 2
**Author:** ![RonMakesSystems](https://sea2.discourse-cdn.com/flex020/user_avatar/community.fibery.io/ronmakessystems/32/14122_2.png) [@RonMakesSystems](https://community.fibery.io/u/RonMakesSystems)\ **Post date:** [May 12, 2025, 9:08pm UTC](https://community.fibery.io/t/allow-to-return-an-empty-value-from-a-formula/2983/21 "2025-05-12T21:08:37Z")
Yes you’re right. Sorry for making a duplicate! Voted there. ---
**Author:** ![tycecycle](https://avatars.discourse-cdn.com/v4/letter/t/848f3c/32.png) [@tycecycle](https://community.fibery.io/u/tycecycle)\ **Post date:** [May 12, 2025, 11:39pm UTC](https://community.fibery.io/t/allow-to-return-an-empty-value-from-a-formula/2983/22 "2025-05-12T23:39:07Z")
I really want this too and had already voted on the other thread - I wanted our collective voice to bump this higher on the Fibery prioritization list 🤞 ---
**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:** [March 5, 2026, 11:51pm UTC](https://community.fibery.io/t/allow-to-return-an-empty-value-from-a-formula/2983/23 "2026-03-05T23:51:34Z")
I’m a bit mortified to realize this doesn’t already exist. I just converted a static number field to a formula in my deals pipeline and realized the field won’t hide itself when there is nothing to compute. If we don’t have this feature, then 0 values should not display in fields set to “hide if empty” ---
**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:** [March 6, 2026, 6:34pm UTC](https://community.fibery.io/t/allow-to-return-an-empty-value-from-a-formula/2983/24 "2026-03-06T18:34:40Z")
Okay, it’s not like me to have missed this so I went back to my workspace to see where empty values are considered empty: 1. You can return “” for string values 2. You can return 0 for integers, and it will be treated as an empty value BUT, this doesn’t work for decimals. ![image](https://us1.discourse-cdn.com/flex020/uploads/fibery/original/2X/7/7be49ed55d4335e2f2848cb3121192edd13f5c78.png) ---
**Author:** ![interr0bangr](https://sea2.discourse-cdn.com/flex020/user_avatar/community.fibery.io/interr0bangr/32/8089_2.png) [@interr0bangr](https://community.fibery.io/u/interr0bangr)\ **Post date:** [March 9, 2026, 4:15pm UTC](https://community.fibery.io/t/allow-to-return-an-empty-value-from-a-formula/2983/25 "2026-03-09T16:15:34Z")
It’s annoying to have to use a workaround, but we use dedicated “NULL NUMBER” fields with the sole purpose of being used in if statements for formulas where we don’t want the field to display as 0. So something like: > if(A \>= 0, A, NULL NUMBER) ---
**Author:** ![RonMakesSystems](https://sea2.discourse-cdn.com/flex020/user_avatar/community.fibery.io/ronmakessystems/32/14122_2.png) [@RonMakesSystems](https://community.fibery.io/u/RonMakesSystems)\ **Post date:** [March 9, 2026, 4:19pm UTC](https://community.fibery.io/t/allow-to-return-an-empty-value-from-a-formula/2983/26 "2026-03-09T16:19:37Z")
This solution from Chris works like a charm for me: [Setting an empty date in automations - #5 by Chr1sG](https://community.fibery.io/t/setting-an-empty-date-in-automations/8771/5) I think it’s quite robust. ---
**Author:** ![JackC](https://sea2.discourse-cdn.com/flex020/user_avatar/community.fibery.io/jackc/32/5420_2.png) [@JackC](https://community.fibery.io/u/JackC)\ **Post date:** [March 10, 2026, 1:36am UTC](https://community.fibery.io/t/allow-to-return-an-empty-value-from-a-formula/2983/27 "2026-03-10T01:36:38Z")
Robust, but kinda hacky and something that really _should_ be able to be done without a workaround. [Previous page](https://community.fibery.io/t/allow-to-return-an-empty-value-from-a-formula/2983.md?page=1)