I created a column with a number format, but when I refer to that column in a formula it shows as a text format??
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
1 Like
Any idea of ETA to fix this? Pretty annoying!
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…
2 Likes
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)
1 Like