AnsweredAssumed Answered

Equations inside of a BOM, multiple IF Then statements

Question asked by Tristan Johns on Nov 15, 2010
Latest reply on Nov 15, 2010 by Tristan Johns

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?

Outcomes