Hi,
As can be seen on the attached, I am trying to determine what is displayed in the DESCRIPTION column based on what is shown in the CODE column. Essentially I would like the DESCRIPTION column to show either the Description or Material properties from the part. I am pretty new to the formula side of things so any help is appreciated.
Thanks!
In equation try to use IIF instead of IF
This one works for me:
IF(`Code`="B";'Description';'Material')
Single quotes around custom properties, double quotes around strings. Basically what you already had.
The IF works just like in Excel: If(condition; when true, when false). In the when true or when false statements you could put another if when required. That's called a nested if. An example:
IF(`Code`="B";'Description';IF('Code'="T";'Material';`Code`))
If code is B, it shows the description.
If code is T, it shows the material.
If code is something else, it shows the code.
Thanks Peter, Now my issue seems to be getting it to work in a cutlist weldment BOM. Still playing around with it but any thoughts would be appreciated.
I think I have it partially figured out. This seems to work for the one variable. Just need to figure out if I have multiple variables.
IF('CODE'="B";`Description`;`Material`), I tried IF('CODE'="B";`Description`;`Material`;IF('CODE'="P";`Description`;`Material`)) but that didn't work.