need some help with sorting a saved search, I am c...
# suiteanalytics
i
need some help with sorting a saved search, I am currently sorting by column 'name' which is an alphanumeric number. The issue I am having is that it isn't sorting as expected, ex. on the screenshot attached is should list 22AU682 before the 22AU1423.
c
It’s a string
☝️ 3
n
I’m addition to @CD maybe you strip out just the digits. Or trying using Internal ID of it has the same sequence
r
Create 3 formula columns. Extract 22 in first column AU in second column Then 682/1423 in third column. Sort by first column, Then by second, Then by third.