Spec Limit and Pass/Fail Column

[#1]

Hi,

I would like to ask if I set a particular column with spec limit(eg. low:100 and max:1000), from this limit set how can I create a corresponding column say Pass/Fail column to label those data within limit as Pass and out of spec as Fail.

Thank you.

[#2 · Accepted solution]

I guess I found the answer from another discussion :) Thanks!
By setting the Formula(in column properties, and use conditional IF function works fine.

If( 100 <= :MAX_MIN Test <= 1000,
"Pass",
"Fail"
)

[#3]

Hi,

Do you have an idea for general purposes- for example: I have 50 columns (all with spec limits property) 

How can I create this fail pass column if the sample (row) fails in one of the parameters?

By the way- I saw solutions to do it in JSL (I'm not so strong in JSL), but I want the functionality that the data will updated simultaneously, same as formula column   

Thanks for help!