# If then... with blank...else **URL:** \ **Category:** Report a Bug\ **Created:** [May 28, 2021, 4:59pm UTC](https://community.glideapps.com/t/if-then-with-blank-else/27360 "2021-05-28T16:59:37Z")\ **Posts on this page:** 14\ **Page:** 1
**Author:** ![Gerard\_Fernandez](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/gerard_fernandez/32/1183_2.png) [@Gerard\_Fernandez](https://community.glideapps.com/u/Gerard_Fernandez)\ **Post date:** [May 28, 2021, 4:59pm UTC](https://community.glideapps.com/t/if-then-with-blank-else/27360/1 "2021-05-28T16:59:37Z")
If then column bringing number columns as result cannot be rolled up as sum if there is not an else value informed…or…the column has values in all rows. ---
**Author:** ![Lucas\_Pires](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/lucas_pires/32/64863_2.png) [@Lucas\_Pires](https://community.glideapps.com/u/Lucas_Pires)\ **Post date:** [May 29, 2021, 1:38am UTC](https://community.glideapps.com/t/if-then-with-blank-else/27360/2 "2021-05-29T01:38:00Z")
Have you tried to insert a 0 (zero) in **Else** field? ---
**Author:** ![Gerard\_Fernandez](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/gerard_fernandez/32/1183_2.png) [@Gerard\_Fernandez](https://community.glideapps.com/u/Gerard_Fernandez)\ **Post date:** [May 29, 2021, 7:33am UTC](https://community.glideapps.com/t/if-then-with-blank-else/27360/3 "2021-05-29T07:33:35Z")
Yes thanks. It should recognize …blank else… as 0 in number columns. Aesthetically sometimes I prefer to show blanks than a lot of zeros. ---
**Author:** ![Lucas\_Pires](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/lucas_pires/32/64863_2.png) [@Lucas\_Pires](https://community.glideapps.com/u/Lucas_Pires)\ **Post date:** [May 29, 2021, 12:52pm UTC](https://community.glideapps.com/t/if-then-with-blank-else/27360/4 "2021-05-29T12:52:50Z")
I feel you. Be our suggestion here @Mark What you can do is create another IFE column When this column is equals 0 \> blank ---
**Author:** ![Mark](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/mark/32/125_2.png) [@Mark](https://community.glideapps.com/u/Mark)\ **Post date:** [May 29, 2021, 5:14pm UTC](https://community.glideapps.com/t/if-then-with-blank-else/27360/5 "2021-05-29T17:14:57Z")
Are you saying Sum doesn’t work if you have empty cells? It should. Empty cells should count as 0. ---
**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\ **Post date:** [May 29, 2021, 5:22pm UTC](https://community.glideapps.com/t/if-then-with-blank-else/27360/6 "2021-05-29T17:22:15Z")
@mark no, the way I understand it what is being said is that if you try and do a rollup on an if-then-else column that contains empty values, then sum is not an available rollup option. Example: ![Screen Shot 2021-05-30 at 1.20.23 AM](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/5/9/59c0e69155df93f33485695c05d9110243e1a228.png) ---
**Author:** ![Mark](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/mark/32/125_2.png) [@Mark](https://community.glideapps.com/u/Mark)\ **Post date:** [May 29, 2021, 6:59pm UTC](https://community.glideapps.com/t/if-then-with-blank-else/27360/7 "2021-05-29T18:59:53Z")
I see! That’s a good point. ---
**Author:** ![Robert\_Petitto](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/robert_petitto/32/25193_2.png) [@Robert\_Petitto](https://community.glideapps.com/u/Robert_Petitto)\ **Post date:** [May 29, 2021, 8:53pm UTC](https://community.glideapps.com/t/if-then-with-blank-else/27360/8 "2021-05-29T20:53:05Z")
Ya, @Mark, I recently talked about this with @JackVaughan this week. If there’s a blank in the result of a case of an if then else column, then Rollup columns no longer see the value as a number but rather a string. The same is true with dates. Can’t do Rollups for earliest/latest. Same is true if I have an if then else that results in “true”/”false”. I can’t do a Rollup to count all true, for example. ---
**Author:** ![Mark](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/mark/32/125_2.png) [@Mark](https://community.glideapps.com/u/Mark)\ **Post date:** [May 30, 2021, 5:40pm UTC](https://community.glideapps.com/t/if-then-with-blank-else/27360/9 "2021-05-30T17:40:43Z")
Will be fixed on Friday. ---
**Author:** ![Robert\_Petitto](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/robert_petitto/32/25193_2.png) [@Robert\_Petitto](https://community.glideapps.com/u/Robert_Petitto)\ **Post date:** [May 30, 2021, 10:10pm UTC](https://community.glideapps.com/t/if-then-with-blank-else/27360/10 "2021-05-30T22:10:50Z")
Awesome! Didn’t even know it was a bug…figured it was simply a type mismatch restriction ---
**Author:** ![system](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/system/32/53398_2.png) [@system](https://community.glideapps.com/u/system)\ **Post date:** [November 12, 2021, 10:28pm UTC](https://community.glideapps.com/t/if-then-with-blank-else/27360/11 "2021-11-12T22:28:17Z")
Closing due to inactivity. This topic will be deleted in a few weeks if there are no more comments. ---
**Author:** ![system](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/system/32/53398_2.png) [@system](https://community.glideapps.com/u/system)\ **Post date:** [November 12, 2021, 10:28pm UTC](https://community.glideapps.com/t/if-then-with-blank-else/27360/12 "2021-11-12T22:28:18Z")
---
**Author:** ![system](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/system/32/53398_2.png) [@system](https://community.glideapps.com/u/system)\ **Post date:** [December 12, 2021, 10:28pm UTC](https://community.glideapps.com/t/if-then-with-blank-else/27360/13 "2021-12-12T22:28:20Z")
---
**Author:** ![system](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/system/32/53398_2.png) [@system](https://community.glideapps.com/u/system)\ **Post date:** [December 12, 2021, 10:28pm UTC](https://community.glideapps.com/t/if-then-with-blank-else/27360/14 "2021-12-12T22:28:20Z")