Tismacfan.

Okay, but if I want to retrieve the name of the material in a column, I get all three materials: Material 1 + Material 2 + the name of the compound material. However, I only want to see the name of the compound material in my worksheet, with its weight calculated next to it. The weight should include the combined weight of Material 1 and Material 2.

Do you also know how to calculate the weight of an object made of a compound material, where the densities of both materials are known:

YYes, you can go ahead and delete this. If Apple or Inc. then provides a solution, you can decompress it again, and you’ll be able to see the thumbnail of your Vectorworks files once more.

This happens when you are in column view on a Mac, and a preview of the file content is displayed. There are two workflows to resolve this issue. Either change the view in your Finder to list view instead of column view, or go to the Applications folder, right-click on the program Vctorworks, and choose “Show Package Contents.” Open the folder Contents > Plug-ins and compress the QLPreviewExtension.appex application.

After some searching, I found it. Your help was very much appreciated, and thanks for pointing me in the right direction

“Sorry, maybe I wasn’t clear due to the language barrier. I’ll try again to explain what I’m looking for. I have a wall with several components, and these components have different materials. In the first cell, I want to retrieve the names of the materials used in these components, for example, ‘brick’. Then, in the second cell, I want to retrieve the value of the record attached to that material, without manually entering the material name, but by referring to Cell A1, where the material name is already located. Is this clearer? It might very well be that what I’m asking for is not possible, of course. I would prefer not to work with the index of the components because, in wall 1, the brick might be component 1, and in another wall, the brick might be component 2.” Let me know if this works!

“Yes, thank you, that’s correct, but I can’t find a formula that gives me the name of the component without using the index. I’d like to retrieve the component name without having to rely on the component’s index.” “And when I use this formula =MATPROPERTYBYNAME(MATERIALNAME,'recordname’.'fieldname'), but I want the material name to refer to a cell where the material name is located, it doesn’t work and I get the error message #PARMS#.”

“Ok, thank you, this does indeed work, but is there a way to retrieve the name of a component in a worksheet without using the index? It’s difficult because in some walls, Component X is in position 1, while in others, Component X is in position 2. I would like to retrieve the material used by this component based on the component name, rather than using the index.”

In the predefined worksheets, there is a worksheet called Materials Data Sheet. When you open it, there is a suggestion on how to retrieve the value of a record field from a record linked to a material. The formula provided is =MaterialProperty('materialname', 'recordname'.'fieldname'). However, when I link a record to a material and enter a field value, I expect to see the field value from my linked material record in this field. But nothing appears. What am I doing wrong? Or does that suggestion no longer work in this worksheet?

Which apps must be removed?

@Pat Now you have the area of all spaces in the drawing. But what if I only want the area from spaces, only on te layer 00 walls?

@Tom, thanks that's indeed what I want. @Pat also thank for your explanation, but I don't see a worksheet in your message P

No, I don't think this works, because the sum of the areas is in a data row, and then you get the repetition of what is in the data row in all cells below it.

If I have all the areas of the space in column A, how can I display these areas in column B as a percentage of the sum of all areas.

Thanks for your answer Pat. The reason I ask is because a customer has a lot of these "legends" on sheet layers and he wants to get them so he can quickly print them.