I'm trying to add an equation to my company's BOM table but I'm not sure if what I'm trying to accomplish is possible. In our top-level assemblies, we don't like to display the property "Description" because it gives our customers too much information. Instead of displaying "MOTOR, TEFC, 447/9T, 200 hp, 460V/3PH/60 Hz, 1750 rpm, NEMA" we want it to simply say "MOTOR." Fortunately, all our parts/assemblies contain another property named "Component" where it says exactly that: MOTOR, COUPLING, SHAFT, etc. The only exception to this is hardware. We want to display the full description for hardware so our customers can easily buy replacements without going through us. We don't give our hardware part numbers; we simply display "HDW" using the "PartNo" property. All other components get a 6-digit number.
Can I designate a column to display the "Component" custom property unless the "PartNo" property value equals "HDW" which in that case we want to display the "Description" property in the cell instead.
Basically: IF 'PartNo'="HDW" display 'Description' ELSE display 'Component'
Is this possible, and if so, how do I format the statement because everything I try does not work? It just fills the cell with the equation like this:
IF('PartNo'="HDW"; 'Description'; 'Component')
Edit: actually, I got that to work. It didn't like the column header being named 'Description.' Once I changed the header it worked. But I'd like to take it one step further. I'd like the statement to display the Description property if it's either "HDW" or "--" (double hyphen).
IF('PartNo'="HDW" OR "--"; 'Description'; 'Component')