Allow to return an empty value from a formula

Ideas & Features
21

Yes you’re right. Sorry for making a duplicate! Voted there.

22

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 :crossed_fingers:

23

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”

24

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
    image484×148 3.61 KB
25

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)

26

This solution from Chris works like a charm for me: Setting an empty date in automations - #5 by Chr1sG

I think it’s quite robust.

27

Robust, but kinda hacky and something that really should be able to be done without a workaround.