Grouping Schedules

[Anonymous]

Good Morning,

I'm trying to group a sheet list schedule based on the first letter of a sheet number.  I've been trying to achieve this, but it appears revit can only group schedule sections if the parameter data is exactly equal.  Now I've seen pictures and examples of what I want to do, so I know it should be possible somehow.  I tried combining parameters but when I did that it no longer came up as an option in the grouping panel.  As an additional question, how would I go about creating a custom name for each section?  Again I've seen pictures of this but in practice I can only get the header to read the same as the data value.

Thanks in advance

[Anonymous]

Update:

I was able to achieve what I wanted by creating another parameter, manually typing in it's name, and grouping the schedule based on this.  However, when I create a new row, this parameter is not automatically set.  I haven't even bothered trying to make it automatic because the formula would be entirely strings and revit does not allow this. (the formula would be something similar to if(DWG No. [contains] "A", "ARCHITECTURAL", "STRUCTURAL") which isn't even remotely possible without creating a key schedule).  If there is some other way to do this so that when a sheet/row is added it's automatically sorted based on the prefix of the number, that's what I'm looking for.

[ToanDN · Accepted solution]

You cannot create a formula based on the Sheet Numbers because they are text parameter.  Below is what I would do.  You just need to select a bunch of Sheets from the browser and enter a number, the formula will give them the proper Discipline and group them accordingly.

[Anonymous]

This is essentially what I ended up doing, but the number process makes it a little easier.  I just had each sheet labeled with its respective discipline.  Thanks.

[ToanDN]

The reason I have the number parameter is so I can sort the sheets per the numbering order. If I sort them by the discipline parameter then it is going to be alphabetical. It doesn't work if I need Structural before Mechanical, for example.

[chrisplyler]

Yeah, I've given my sheets a "SheetOrder" parameter, and just set up my project browser to order my sheets according to that parameter. Kinda lame, but it does what I want and it was easy.

[Anonymous]

I like @ToanDN solution. I do the same as @chrisplyler though. I need to sort my sheets anyway in the project browser, a parameter is the simplest and easiest for others to use and understand.