William Peacock

complex formula in SW BOM

Discussion created by William Peacock on Dec 7, 2006
Latest reply on Dec 8, 2006 by William Peacock
I have had to develop complex formulas in Excel to auto-populate the balloons & the corresponding item#. This is working well for us. However, every time there is a change to any part in the assembly, that changed part is moved to the bottom of the BOM & changed all the other # as well. If I understand the SW BOM correctly, it does not do this, but I have been having trouble getting the formulas to work. Any one know of a good reference site or material? I have attached the Excel version we are currently using.

Thanks,
bill

Outcomes