Hello,
I am using Revit 2017 and trying to merge 2 columns together but the merge command is grayed out. I have never used the merge command before so I am not sure how it connects with everything. I am trying to merge together our room prefix with our room number. The room prefix is a parameter we created and we wanted it separate because if we had to make a change we just wanted to change it in one spot and not every single room. Is there a way to merge these columns together instead of going through room by room and adding in the prefix?
I have attached some screenshots on the word file of the parameter and the columns in the schedule I am trying to combine.
Thanks in advance
Gelöst! Gehe zur Lösung
Gelöst von barthbradley. Gehe zur Lösung
You can only merge title cells. Select title row and press insert below. A row will insert below, divided by the number of columns you have in your schedule. Those columns can be merged.
As far as for the columns themselves, you cannot merge them. But you can create a concatenated parameter row that combines the values from selected column fields.
So it sounds like the merge command will not help to combine the 2 columns I want, do you have or know of any other ways I could combine these together?
Sorry I did not see the full response above about that concatenated parameter. I take it this is not available in Revit 2017? I do not know anything about concatenated parameter so I will have to do some looking into that.
I don't believe it was available in 2017. I can't remember for sure. But the tool allows you to combine the Values from different columns in the same row. For instance, Mark="A" and Description="B", so Concatenated="AB".
@barthbradley wrote:
I don't believe it was available in 2017. I can't remember for sure. But the tool allows you to combine the Values from different columns in the same row. For instance, Mark="A" and Description="B", so Concatenated="AB".
Concatenated?
@ottestad.peter... In the schedule properties on the Fields tab the last icon in the middle between Available Fields and Scheduled Fields is "Combine Parameters". This allows you to concatenate the parameters.
(Had to Google Concatenate...have to admit I have never used it.)(Yes, this is in Revit 2017)
Small hack if you don't want to use concatenate... though even I would prefer the solution others provided...
Custome formating.. this affects only once placed on Sheet.. These schedule are placed on sheets..
Sie finden nicht, was Sie suchen? Fragen Sie die Community oder teilen Sie Ihr Wissen mit anderen.