Jody Stiles

BOM if...then help please

Discussion created by Jody Stiles on Jan 28, 2009
Latest reply on Apr 1, 2009 by Jody Stiles
I'm not sure this is possible but I'd like to do the following:

In the quantity column in my BOM I want to show the amount (feet, ounces, etc) of an item used but only if that value is not blank in the part or assembly, if the value is blank then I can to use the quantity of the item in the assembly.

So basically...

If (Amount <> "") Then (cell value = Amount) Else (cell value = Quantity)

Outcomes