vLookup Group By

[Travis Goodman]

Hey Alex,

I have a need to group by a particular field, that starts with a number, but it’s not treating it like a number. It orders them based on the first number, but not larger numbers that go beyond a single digit. 10 will be right below 1, for example. I need them in truly numerical order, but right now I get the following:

1 – Group 1
10 – Group 10
2 – Group 2
3 – Group 3
31 – Group 31
4 – Group 4

I did come up with a calculated column to just have the number value, but then got an error that calculated columns can’t be used in the group by section. I also tried just a plain number field, but you can’t use a number field at all for grouping either.

What do you suggest?

[Alexander Bautz]

Hi,
If you sort by a number field it is sorted numerically, but if you sort by a text field, it is sorted alphabetically. It will sort correctly if you write it like this:

01
02
03
…
10
11

Alexander

[Travis Goodman]

This site collection has an outdated version of Modern DFFS, I’ll update it and try again. Right now number fields are sorting in the style I previously mentioned, but even worse it has a decimal with a ton of trailing 0’s.

[Author]

Posts