Hoping someone already has a solution to this, but after our team searching the community archives, we were unable to find a workable solution.
Is there a way to display a Number Column without a comma and still have it sort numerically?
That may sound strange but we have “Store Numbers” that are basically a Name for that Task (that needs to be sortable so it can not be the pulse name), but also a number. So we have it setup as a number column so it will sort properly. The downside to this is that with it being a number, it inserts the comma that drives us all a little nuts because the Store Number doesn’t include a comma. We have also tried putting this as a text column but that is not sortable.