Feature Request: Setting custom formatting for Number Columns

Submit an Idea
, ,
1

The number column in Monday is currently formatted in the default US decimal format:

1,500.00
Thousand separator = .
decimal separator = ,

The company I work for however, is situated in Denmark and we have the reverse number formatting:

1.500,00
Thousand separator = ,
decimal separator = .

We use Monday as our task and project management system as well as CRM and sales system, and we need to send out invoices and log, for instance, Deal values. We have automated some of our invoices and documents, but each time we use data from a column value we first have to convert the formatting of these numbers before we can actually use them. It would be of great help if we can have a feature that allows us to select which formatting we want to use in a particular numbers column.

Number column example

2

Hi @LindaFuchsUTN!

As of very recently we introduced localisation for the numbers column, which enables the browser to take the PC localisation configuration for the for numbers column and will not override it’s logic - as such, you should now be able to use “,” - that said it appears this isn’t the case on your end? Would you be happy to share a screenshot so I can share this with our developers team? :pray:

3

Hi @BiancaT ,

I actually noticed I made a mistake when I wrote the original post last week. (it was a long week :sweat_smile:).
I mixed up the delimiters in the explanation.
The core of the issue still remains the same though:

US:
1,500.00
Thousand separator = ,
decimal separator = .

Eu:
1.500,00
Thousand separator = .
decimal separator = ,

My format is still showing as US format
image

I also asked one of my colleagues, theirs shows EU format
image

I am guessing it would be a setting in the system that prevents the browser from accessing the location of my device properly. Which would make sense as I have location services for the PC turned off by default. So am I correct in guessing it would display a default format, being the US format?

I do have a few questions about location services if you don’t mind?

  • Why not use the location as it is set on the user’s profile in Monday?

  • When I hover over a colleague in monday, it shows me their location, but that is not the location that they have set themselves in their monday profiles. Some have Copenhagen as their location (which is incorrect, as we are located in Aalborg, DK), but others whom are sitting next to me, on the same network, are showing as being in Budepest, which is definitely incorrect.
    I am guessing that this location depends on where the packet is traced from. But again, why not just use the location we set ourselves in our profile? That would give a much more uniform (and accurate) experience.
    image