I am trying to write an equation inside of a BOM so that it can drive what populates the field inside the column.
Is it possible to have multiple "=" values inside of a Solidworks native BOM file. From what I can gather it is possible inside of an Excel based BOM using VB and other methods. What I want is to make it work inside of a SolidWorks based BOM.
Here is an example of how I am trying to write my equation pasted below.
IF(`CUSTOM PROPERTY`="VALUE1";"TITLE";(IF(`CUSTOM PROPERTY`="VALUE2";"";IF(`CUSTOM PROPERTY`="VALUE3";"";`SW-File Name(File Name)`))))
The problem is that one of my statements overrides the others.
Is my formatting wrong or is it just not possible to have multiple equal values inside a Solidworks BOM?