I had this working properly and now it isn't working again. I have a project that has A100 and B100 Areas. The "A" area has a second floor. I want the A200 Area doors to come after the A100 and B100 doors. I placed quote marks around the data it is pulling from the PSD and still nothing.
How are your room numbers created?
--Are you manually typing in the entire room number into one manual property?
--Are you deriving the "A" or "B" from an automatic Project Property referencing the Division (if using Project Navigator), or from a separate manual property (if not using Project Navigator)?
--Are you deriving the numeral for the floor ("1" or "2" in your example) from a separate property (automatic Project Property referencing the Level property if using Project Navigator or a manual property otherwise)?
The reason I ask is that the easiest way to get a Schedule Table to sort the way you want would be to include an additional, hidden column that indicates the floor level, and sort on that column first, then sort on your room number column. That would get all spaces on the first floor up top, followed by those on the second floor.
If you are just entering the entire room number in one manual property, you may want to consider breaking it up into components and then useing a formula property to concatenate them into the room number. The alternative would be to set up a formula property to "extract" the floor level information from the room number, and use that property as the initial sorting property in the Schedule Table. If your room numbering follows consistent rules for the letter prefixes and floor level indicators, it would not be too hard to extract the floor level. It would be easier, of course, to start out with separate values.