Sort a sheet list by 3 parameters

Revit
1

Hi, I’m trying to create a sheet list and sort them using 3no. different parameters, as I have in the schedule.

Sort fist by ‘RH-Group 01’, then by ‘RH-Group 02’ and then by ‘Sheet Number’. I know how to sort the list with only 1 parameter then when I try sorting again it loses the first.

Any idea how to do it?

image
image1563×722 130 KB

2

try getting the values of 3 parameters separately, use List.SortNatural by Genius Loci then List.Create. Check what you’ll come up with.

3

I tried but it doesn’t quite work. Because if I sort it individually it will work as I want for ‘RH-Group 01’ and ‘RH-Group 02’ as they have to be sorted alphabetically, but for the ‘Sheet Number’ it will sort numerically and I want to it sort first using the other two parameters and then sort numerically.

First example if I sort using the first two parameters I’ll get:
00-0100
01-0100
02-0100

00-0400
01-0400
02-0400.

But sorting just the 'Sheet Number I’ll get:
00-0100
00-0400

01-0100
01-0400

02-0100
02-0400

4

There are many topics that already cover how to sort by multiple values. Try some of them and see where that gets you. The common options are to use SortByKey or to combine values.