Continue to Site

Eng-Tips is the largest engineering community on the Internet

Intelligent Work Forums for Engineering Professionals

  • Congratulations cowski on being selected by the Eng-Tips community for having the most helpful posts in the forums last week. Way to Go!

Can you link multiple properties into one column on a BOM? 1

Status
Not open for further replies.

SWUSER71

Marine/Ocean
Aug 10, 2010
22
I want to link multiple custom properites to one column on a BOM. Does anyone know how to do this?
I wan to take 2 custom properties
Description
Size

and show them in the same column as
Plate - 1/2" THK
 
Replies continue below

Recommended for you

I did it with the Excel-based BOM and it was a P-A-I-N!

Perhaps you can have two columns and hide the vertical border?
 
You could also combine custom properties into a single property, and call that into the BOM.
 
SWUSER71,

You can construct text strings in Excel consisting of elements of the other cells. Note the ampersands connecting each element in the cell.

Cell B2=3.14159265897
Cell B3="M2.5x0.7"
Cell B1="SCREW "&B3&" LONG X "&B3

Resulting cell B1...

SCREW 3.14159265897 LONG X M2.5x0.7

Critter.gif
JHG
 
Thanks CorBlimeyLimey!!
That's what I wanted... just didn't know what to search for.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor