It has been almost 4 years now since I first asked this question. I'm hoping there may be someone with an answer by now...
I have a SW BOM in which I have three columns that display X_DS, Y_DS & Z_DS (x, y & z values of a part)
I want to combine the three columns into one column called "FINISHED SIZE" that would display a callout something like this: .375 x 2.250 x 4.000 (smallest no. first & largest no. last) Here's the kicker, X_DS=2.250, Y_DS=4.000 & Z_DS=.375 BUT sometimes the values may be different, ie. X_DS=.375, Y_DS=4.000 & Z_DS=2.250....... I always want the value in the "FINISHED SIZE" column to display as (small # x medium # x large #)
Any help is appreciated