Revit Architecture Forum
Welcome to Autodesk’s Revit Architecture Forums. Share your knowledge, ask questions, and explore popular Revit Architecture topics.
abbrechen
Suchergebnisse werden angezeigt für 
Anzeigen  nur  | Stattdessen suchen nach 
Meintest du: 

Merging Cells in Room Schedules

7 ANTWORTEN 7
GELÖST
Antworten
Nachricht 1 von 8
ottestad.peter
10750 Aufrufe, 7 Antworten

Merging Cells in Room Schedules

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

7 ANTWORTEN 7
Nachricht 2 von 8
barthbradley
als Antwort auf: ottestad.peter

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.  

Nachricht 3 von 8
ottestad.peter
als Antwort auf: barthbradley

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?

Nachricht 4 von 8
barthbradley
als Antwort auf: ottestad.peter

Do you concatenated parameter? It was introduced in 2018. 

Nachricht 5 von 8
ottestad.peter
als Antwort auf: barthbradley

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.

Nachricht 6 von 8
barthbradley
als Antwort auf: ottestad.peter

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". 

Nachricht 7 von 8
Anonymous
als Antwort auf: barthbradley


@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)

Nachricht 8 von 8
Corsten.Au
als Antwort auf: ottestad.peter

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..Custome formating.. this affects only once placed on Sheet.. These schedule are placed on sheets..

Corsten
Building Designer

Sie finden nicht, was Sie suchen? Fragen Sie die Community oder teilen Sie Ihr Wissen mit anderen.

In Foren veröffentlichen  

Autodesk Design & Make Report