# Column format is not the same in table vs in formula

**URL:** <https://connect.superhuman.com/t/column-format-is-not-the-same-in-table-vs-in-formula/49495>\
**Category:** Bugs\
**Created:** [June 20, 2024, 6:38pm UTC](https://connect.superhuman.com/t/column-format-is-not-the-same-in-table-vs-in-formula/49495 "2024-06-20T18:38:21Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![Jean\_Marc\_Dieu](https://yyz1.discourse-cdn.com/coda1/user_avatar/connect.superhuman.com/jean_marc_dieu/32/32512_2.png) [@Jean\_Marc\_Dieu](https://connect.superhuman.com/u/Jean_Marc_Dieu)\
**Post date:** [June 20, 2024, 6:38pm UTC](https://connect.superhuman.com/t/column-format-is-not-the-same-in-table-vs-in-formula/49495/1 "2024-06-20T18:38:21Z")

</div>

I created a column with a number format, but when I refer to that column in a formula it shows as a text format??

 ![image](https://global.discourse-cdn.com/coda1/original/3X/9/a/9a454db41b73f38ec221d853787a332325b9bbca.png)

---

<div class="post-metadata">

**Author:** ![Piet\_Strydom](https://yyz1.discourse-cdn.com/coda1/user_avatar/connect.superhuman.com/piet_strydom/32/19269_2.png) [@Piet\_Strydom](https://connect.superhuman.com/u/Piet_Strydom)\
**Post date:** [June 20, 2024, 6:43pm UTC](https://connect.superhuman.com/t/column-format-is-not-the-same-in-table-vs-in-formula/49495/2 "2024-06-20T18:43:11Z")

</div>

Hi Jean,

It is a known bug/feature… It usually happens if you created a column with one type, and then entered data of another type.

P

---

<div class="post-metadata">

**Author:** ![Jean\_Marc\_Dieu](https://yyz1.discourse-cdn.com/coda1/user_avatar/connect.superhuman.com/jean_marc_dieu/32/32512_2.png) [@Jean\_Marc\_Dieu](https://connect.superhuman.com/u/Jean_Marc_Dieu)\
**Post date:** [June 20, 2024, 7:02pm UTC](https://connect.superhuman.com/t/column-format-is-not-the-same-in-table-vs-in-formula/49495/3 "2024-06-20T19:02:19Z")

</div>

Any idea of ETA to fix this? Pretty annoying!

---

<div class="post-metadata">

**Author:** ![Piet\_Strydom](https://yyz1.discourse-cdn.com/coda1/user_avatar/connect.superhuman.com/piet_strydom/32/19269_2.png) [@Piet\_Strydom](https://connect.superhuman.com/u/Piet_Strydom)\
**Post date:** [June 20, 2024, 7:07pm UTC](https://connect.superhuman.com/t/column-format-is-not-the-same-in-table-vs-in-formula/49495/4 "2024-06-20T19:07:59Z")

</div>

Hi,

Don’t know whether there are plans to “fix” it, it was a design feature based on early user requirements to have “weak typing” of data types. Hence the quotes around fix, some people actually prefer the way it currently works.

I am not one of them…

---

<div class="post-metadata">

**Author:** ![Jean\_Marc\_Dieu](https://yyz1.discourse-cdn.com/coda1/user_avatar/connect.superhuman.com/jean_marc_dieu/32/32512_2.png) [@Jean\_Marc\_Dieu](https://connect.superhuman.com/u/Jean_Marc_Dieu)\
**Post date:** [June 24, 2024, 5:05pm UTC](https://connect.superhuman.com/t/column-format-is-not-the-same-in-table-vs-in-formula/49495/5 "2024-06-24T17:05:02Z")

</div>

I can understand the weak typing of data types and don’t have a problem with it per se.

What I have a problem with is lack of consistency: showing a column is a number on the table and that it is a text on a formula (and generating an error due to that). User should be able to override it manually (maybe that’s a new feature request) AND it should stay consistent (inconsistency IS DEFINITELY A BUG)