Sort list number in ascending order

Revit
1

Hello im trying reorder my sheets from the project browser but its messed up when i tried to. Is there a way sort this? My project browser is below:

image

I want to sort it like 01-29 where drawing list and notes comes first like the image markup, then the rest will follow as is like the 5th sheet would be the #1 (architectural roof plan) then #2 (architectural -floor plan). I tried work on it (please see below comments as I cant post multiple images in my post).

Thank you and more power!

2

Here is what i have tried. its still not in order.

image
image.png1689Ă—969 115 KB

3

Hi @Richard.P.Garcia

Could you drop here rvt file with only sheets in it?

4

Hi Kulkul,

Here is the model. I am trying to sort base on the “DRAWING NUMBER” in a format MHU\UAB 00 501-XX (where XX is sheet number i.e. 01, 02, 03 format etc. see the sheet list.

see here: https://drive.google.com/file/d/1tqBmOXq2_yhdthUS_I8u-7i3F-RRHc-j/view?usp=sharing

5

Hi @Richard.P.Garcia

Is this what you’re trying to achieve?

image
image847Ă—677 93 KB

1 Like
6

Maybe you can try this before you feed it into List.SortByKey.

x100
x100.jpg891Ă—353 83.6 KB

7

Richard,

One of the issues is that Revit stores the Sheet number field as text (string) and when you sort a string it orders it the way you see it. If you convert the string to a number using the node String.ToNumber. It might sort the way you are looking, but it also might mess up the numbers that have a zero prefix. If that is the case, you might have to do a little data manipulation to isolate the sheet numbers that start with zero.

Nick

8

this is a method of sorting with string’s

x100%20string
x100 string.jpg967Ă—523 136 KB

1 Like
9

The only solution is provided by Kulkul.