I am wanting to sort by more than 4 parameters in a single schedule. Revit 2012 only has 4 options. Can more be added?
Solved! Go to Solution.
Solved! by jverdugt. See the answer in context.
Thanks for the reply. We were able to figure out a way to work around this to the accuracy we needed.
Just following up on Alfredo’s post. Without more information it’s impossible to make recommendations and/or suggestions.
Hi, how did you solve this? We have the same problem.
We have a schedule listing window information, e.g. Window Type F01.
We sort our Schedule by:
Type Mark, then by:
SwingDirection, then by:
FireClass, then by:
And we need to add by:
But Revit has by default only 4 levels or sorting.
Any ideas how we can go about adding more sorting parameters?
I have accomplished this in the past by creating a Calculated Value that combined two of the fields for the purposes of establishing a sort order for our Light Fixture Schedule. I already had the top two "Sort Slots" used, so I had to combine LampWattage and LampQuantity (to be sorted in respective order) into a single sort. This is a rough summary of my scenario:
Name Type Units
LampWattage Parameter Watts
LampQuantity Parameter Integer
LampSort Calculated Value Number
The formula for LampSort is: =(LampWattage / 1 W) + (LampQuantity / 100)
The above formula will combine the two to produce a number such as 32.03 (32W, 3-Lamp) or 54.01 (54W,1-Lamp), which allows for proper sorting.
As for your specific situation, I would assume that your Parameters "SwingDirection", "FireClass", and "SoundClass" are all Text Parameters, correct?
It may still be possible to combine them using this method, but could you elaborate on your parameters a little bit, specifically, are there a large number of possible values for these parameters? I'm thinking there are aren't many possibilities for "SwingDirection", but what about the other two?
Unfortunately, Revit is incapable of the simple task of combining text strings, which is responsible for the forehead-shaped damage to my desk.
My questions earlier about the number of possible values is important to this method - the more values, the more complicated it becomes. Example:
I want to combine BoxSize and BoxColor, which are both Text parameters. I would first have to create a Calculated Value for each of these that will convert the value to an Integer. Here is the formula for the respective Calculated Values:
BoxSizeSort = if(BoxSize = "Small", 1,if(BoxSize = "Medium", 2, 3))
BoxColorSort = if(BoxColor = "Blue", 1, if(BoxColor = "Green", 2, if(BoxColor = "Orange", 3, if(BoxColor = "Red", 4, 5)))
**The above formulas must include ALL possibilities, so if there are limitless options, then this is not possible.
Finally, a third Calculated Value is needed to combine the other two: BoxSort = BoxSizeSort + (BoxColorSort / 10)
Edit: Nevermind the above in the spoiler - I had forgotten that Revit does not allow a String to be used in a conditional statement... More
Ok, thank you for helping out!
Maybe the conversion to text may be too elaborate for this project.
How ever, the calculated value idea makes me think we will have to combine two parameters into one to simplify matters. Hope Autodesk will give us more control in future versions though.
Thank you for quick replies!
Unfortunately, with all of the parameters being Text, I believe that you will have to combine them outside the schedule. I'll post if think of any other possibilities...
Access a broad range of knowledge to help get the most out of your products and services.